This code demonstrates how to
This is a Web-based script
Create a connection to DBF
This is a complete tutorial
use an MD5 hash to encrypt
writer that generates an ASP
files using JetOLEDB
on adding records to the
user passwords when storing
code for displaying an
provider (DSN-less,
database via ASP for
them in a database. There
Access or SQL Server
ODBC-less connection), basic
beginners. Both Connection
are constantly news items
database using
work with DBF files (select,
and Recordset Objects
about companies where user
user-submitted variable
insert, update), other ISAM
discussed. Also get an
information is compromised.
names and the name of the
formats + FOXPRO option,
insight on 'insert' SQL
By storing passwords using
table. Copy the output code
real sample code, create a
statement.
an MD5 hash, even if your
into an asp document on your
new DBF file.
database is compromised the
web server and your db is
passwords cannot be decoded.
ready to be displayed on the
The only downside is that
web. The DSN connection
users cannot retrieve lost
requires that you register
passwords, they must reset
the DSN for the db prior to
them.
executing the code.
Date: Sep, 18 2006 Date: May, 21 2001 Date: Jun, 18 2003 Date: Mar, 25 2000 |
In order to connect to an
This is a sample code that
Adding a record from a
This is an example code
Acees database with ASP
combines a Database Paging
database table is a simple
showing how to conduct
through ODBC using a DSN
and a Database Search script
task. Fill out the form
searches on a database to
file, you'll need to have
into one. It shows you how
below and click submit. The
display hyperlinked
full access to the server to
to perform a wilcard search
sql statement will be
summaries that can be
create the DSN file,
on a database table and then
generated for you.
clicked on to display detail
something that can be
page through the results.
data.
difficult if your site is
hosted somewhere. This
lesson will teach you an
alternative connecton
method, a DSN-less
connection. As tests has
shown, an DSN-less
connection to Access gives
you better performance. You
can have up to 20-30
simultaneous users on the db
without problems.
Date: Mar, 12 2000 Date: Apr, 25 2001 Date: Apr, 15 2002 Date: May, 21 2001 |