There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server connection.
This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine. After a System DSN has been created you can use it within any ASP page located on the same computer.
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records
were returned from a query, and how to detect null and blank values in the data.
You fill in the blanks, and you are given the source code for the form, and a page to display the information in the database. Also the database is ready to download with all fields in your form.
A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available.
This article shows how to insert records to a database, when the number of records that need to be inserted is unknown. A must read for ASP/ADO programmers.
This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.
This code demonstrates how to use an MD5 hash to encrypt user passwords when storing them in a database. There are constantly news items about companies where user information is compromised. By storing passwords using an MD5 hash, even if your database is compromised the passwords cannot be decoded. The only downside is that users cannot retrieve lost passwords, they must reset them.
0.0
1.0
5.0