/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Working with ASP & MS Access

Hits: 20
*****
0.0

SQL Tutorial

Hits: 20
*****
0.0

Executing Transact-SQL DELETE statement

Hits: 19
*****
2.0

Access and SQL Server DSN-LESS connections

Hits: 19
*****
0.0
This is a nice simple
SQL, Structured Query
In this example, we will
There are a few different
tutorial on how to
Language, is the most
delete some records from a
ways to connect to an Access
manipluate a MS Access
powerful tool to connect to
database. This source code
database using a DSN-LESS
database using ASP. It will
a database regardless of the
helps us to deleting records
connection. You can use the
teach you how to add, remove
form of the database.
to database without slowing
Access driver, an OLEDB
and modify data from an
However, building a perfect
down database.
provider connection, a
Access database as well as
SQL statement can be very
 
physical path or a virtual
connecting and disconnecting
frustrating. Especially
 
path. Here is an example of
to the database in ASP.
debugging -- the error
 
each as well as a DSN-LESS
 
message simply didn't tell
 
SQL Server connection.
 
you where the error is. This
 
 
 
tutorial provides a nice
 
 
 
summary of SQL statements.
 
 


Date: Mar, 12 2000


Date: Feb, 15 2000


Date: Dec, 18 2003


Date: Aug, 05 2002
Step-by-step tutorial on how
Adding a record from a
So you need a DSN-Less
Insert a table into a
to display uploaded binary
database table is a simple
connection but your not
database dynamically. You
files from the database
task. Fill out the form
quite sure what to do. Well
don't even have to open MS
using plain ASP pages. Every
below and click submit. The
we can do this for you. A
Access. One simple asp does
step has been explained in
sql statement will be
quick and easy way to make a
the trick. Using ADOX you
detail. Downloadable source
generated for you.
connection without a DSN.
can add and manipulate
code available.
 
This will work for your MS
tables easily once you know
 
 
Access database only. Now
how.
 
 
includes SQL Server.
 


Date: Jun, 17 2002


Date: Apr, 15 2002


Date: Apr, 15 2002


Date: Apr, 15 2002
{ Copyright } ©2006 NuclearScripts.com