DSN-less Database Code Generator

If you use Access or SQL databases on one of Internet Connection's Windows-based hosting packages, you should consider using a DSN-less connection, as this will provide faster database access time.

The performance increase that occurs when using a DSN-less database connection results from the server not having to perform a registry lookup on database queries. Further performance increases may be achieved if one utilizes the OLE API instead of ODBC.

The DSN-less Code Generator can be used with Access and SQL databases and supports both ODBC and OLE databases interfaces.

This document will help you start using DSN-less database connections by generating all of the necessary code for your .asp documents.

Note: Your database(s) should reside in a directory named "database" in the root of your account. If this directory does not exist you can create it but please contact the support desk to set the correct permissions for it. It is not recommended that you place your database(s) in your HTML directory as anything in the HTML directory can be accessed and downloaded.

For Access Databases

IMPORTANT: Enter the path to your database as if you were in your home directory. This means if you uploaded the database mydb.mdb to html/data you would enter in html/data/mydb.mdb in the field below labelled Database name.

Database name:
My database uses:	ODBC OLE

For SQL Databases

Database name:
Username:
Password:
My database uses:	ODBC OLE