In order to administer your StoreFront web, configuring settings and adding products to the database, you must first connect to the database using the StoreFront client tools. Anytime you try to open one of the StoreFront 5.0 or StoreFront 2000 development tools, you will be required to enter database connection information into a dialog box. This article describes the information required by the database connection box in StoreFront 5.0 and StoreFront 2000, and how to enter it.
If you are trying to connect with the StoreFront 2000 or 5.0 client tools to a database in a web hosted on your local machine, try the following settings in the database connection dialog box: Host: localhost
DSN: the entry for this field should be the system DSN set on your local machine (through the ODBC Administrator, System DSN, etc)
Use Remote Database Connection should be unchecked.> Use Data Handler should be unchecked. If you run into an error referring to a data handler or saying that "the default RDS handler has denied access", then check this option and try again.
MS Access or Access should be selected. The Logon required box should be unchecked and both login and pasword fields should be left blank. StoreFront 5.0 users should also leave the Use custom connection string option unchecked. Click OK or Connect for StoreFront 5.0. Do you encounter an error?
If you continue to encounter errors, double-check your settings and try again. If the error persists, contact StoreFront Support. If you are trying to connect with the StoreFront 2000 or StoreFront 5.0 client tools to a database in a web hosted on a remote web server, try the following settings in the database connection dialog box: Host: this field should be contain either your site's domain name or your ip: www.(your_domain).com or 123.456.687.910 (your ip)
DSN: the entry for this field should be the system DSN set on the remote web server (through the ODBC Administrator, System DSN, etc)
Use Remote Database Connection should be checked.
Use Data Handler should be checked. If you run into an error referring to a data handler or saying that "the default RDS handler has denied access", then check this option and try again.
MS Access should be selected. The Logon required box should be unchecked and both login and pasword fields should be left blank. StoreFront 5.0 users should also leave the Use custom connection string option unchecked. Click OK (StoreFront 5.0 users click Test Connection, then Connect). Do you still encounter an error?
If you encounter an error saying "Internet Server Error", contact your host and request that the MSADC service be established for this web, as described in the Database Connectivity Configuration section of Webhost Support.
