/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

Adding Records to the Database

Hits: 865
*****
0.0

DSN-less MS Access connection

Hits: 865
*****
0.0

Database Paged Search

Hits: 851
*****
0.0
This is a complete tutorial
In order to connect to an
There are a few different
This is a sample code that
on adding records to the
Acees database with ASP
ways to connect to an Access
combines a Database Paging
database via ASP for
through ODBC using a DSN
database using a DSN-LESS
and a Database Search script
beginners. Both Connection
file, you'll need to have
connection. You can use the
into one. It shows you how
and Recordset Objects
full access to the server to
Access driver, an OLEDB
to perform a wilcard search
discussed. Also get an
create the DSN file,
provider connection, a
on a database table and then
insight on 'insert' SQL
something that can be
physical path or a virtual
page through the results.
statement.
difficult if your site is
path. Here is an example of
 
 
hosted somewhere. This
each as well as a DSN-LESS
 
 
lesson will teach you an
SQL Server connection.
 
 
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, 25 2000


Date: Mar, 12 2000


Date: Aug, 05 2002


Date: Apr, 25 2001
Adding a record from a
This is an example code
Displaying specific subsets
ODBC is great and all but for
database table is a simple
showing how to conduct
of data from a database is
speed and reliability you
task. Fill out the form
searches on a database to
easy to accomplish in .asp.
should switch to OLE DB to
below and click submit. The
display hyperlinked
The following example
power your database driven
sql statement will be
summaries that can be
utilizes an Access database
apps. This tutorial will
generated for you.
clicked on to display detail
of Mark "The Bird"
show you how to do it two
 
data.
Fidrych and displays all of
ways: in the global.asa and
 
 
his season statistics for
in any ASP page.
 
 
1976 contained in the
 
 
 
database rather than
 
 
 
displaying the entire db.
 


Date: Apr, 15 2002


Date: May, 21 2001


Date: Jan, 20 2000


Date: Feb, 13 2000
{ Copyright } ©2019 NuclearScripts.com