The most commonly used database format by our customers is Microsoft Access, but other types of databases can be used as well.  When a database resides on a web site, a connection needs to be made to it in order to allow it to be used on the web server.

TYPES OF DATABASE CONNECTIONS
A database connection (or ODBC connectivity) can be in the form of:

• File DSN
• System DSN
• DBQ Connection string or...
• A database connection created within a web editor software
  (such as Microsoft FrontPage).

All of our web hosting accounts include the ability to use one or more databases within your web site.  You can create your own database connections anytime you like using a File DSN or the database connection tools in Microsoft FrontPage for many types of database file formats.

WHAT'S THE DIFFERENCE?
A System DSN stores your database connection information in the system registry of the Web server.  When your database connection must be "hard wired" in the registry of the web server - this is referred to as a System Data Source Name (also called a System DSN).  This is essentially a static connection, therefore you cannot easily move or rename your database file.

In contrast a File DSN or DBQ Connection string stores your database connection information in a file that resides in your Web site.  This allows you a little more flexibility if you need to change your connection information or database file name.

WHEN TO USE A SYSTEM DSN
More robust ASP applications including some shopping cart systems may require a System DSN to function correctly. 

The System DSN is configured by a Server Administrator at Acme Internet on the web server on which your web site resides.  It offers the functionality of providing the necessary database drivers and uses a simple name (DSN) to reference the complete file name and path of your database file.

Visit our web hosting section to find out if the hosting account plan you have includes the ability to use a System DSN.  Some of Acme's hosting accounts include support for one or more System DSNs.  They can also be purchased on an ala carte basis.   See http://www.acmeinternet.com/services for information. 

When you are ready to use a System DSN on your web site:

1. FIRST: Upload the database file to your web site.
2. Complete the DSN/database request form that includes...
3. Your domain name/web site address and username
4. The DSN name that you wish to use (i.e.: MYINVENTORY )
5. The filename and directory on your site where we can locate the database to set up the DSN

Please remember, you will be responsible for all the code necessary in your web pages to display and manipulate data in your database.   Support for database design or scripting issues is not included with our free technical support.