This code demonstrates how to
Create a connection to DBF
This is a Web-based script
This is a complete tutorial
use an MD5 hash to encrypt
files using JetOLEDB
writer that generates an ASP
on adding records to the
user passwords when storing
provider (DSN-less,
code for displaying an
database via ASP for
them in a database. There
ODBC-less connection), basic
Access or SQL Server
beginners. Both Connection
are constantly news items
work with DBF files (select,
database using
and Recordset Objects
about companies where user
insert, update), other ISAM
user-submitted variable
discussed. Also get an
information is compromised.
formats + FOXPRO option,
names and the name of the
insight on 'insert' SQL
By storing passwords using
real sample code, create a
table. Copy the output code
statement.
an MD5 hash, even if your
new DBF file.
into an asp document on your
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: Jun, 18 2003 Date: May, 21 2001 Date: Mar, 25 2000 |
In order to connect to an
This is a sample code that
This is an example code
Adding a record from a
Acees database with ASP
combines a Database Paging
showing how to conduct
database table is a simple
through ODBC using a DSN
and a Database Search script
searches on a database to
task. Fill out the form
file, you'll need to have
into one. It shows you how
display hyperlinked
below and click submit. The
full access to the server to
to perform a wilcard search
summaries that can be
sql statement will be
create the DSN file,
on a database table and then
clicked on to display detail
generated for you.
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: May, 21 2001 Date: Apr, 15 2002 |