StoreFront Ecommerce News for FrontPage & Dreamweaver
Press CTRL+D to Bookmark StoreFrontGoodies.com
Click Here to sign up for our Monthly Newsletter.

| Home | New Forum! | StoreFront 6 | StoreFront 6 Add Ons | Search Engine Optimization | Essential Tools | StoreFront 5 | StoreFront 2000 | SFG Partners | Participate | Suggestion Box | Security |

home > storefront 2000 > storefront 2000 knowledge base

| StoreFront 2000 Knowledge Base |


Type Mismatch Connection.Open Global.asa line 110
 

Posted Friday, April 23, 2004

This error is the result of a broken connection to the web store's database. Follow the instructions below to reapply a database connection to your site and resolve this error:

STOREFRONT FOR FRONTPAGE

Open your web in FrontPage. You can do this by clicking on File, then Open Web. In the Folder Name field, enter the URL to your web site on the live server or local machine.

After the web opens, click Tools, then select Web Settings.

Click on the Database tab. Click Add.

Leave the Name set to the default of Database1, or use a brief name of your own choosing. Select File or folder in current web, then click Browse. Browse to the location of the database within the web (this should be the fpdb folder) and highlight the file by clicking on it.

If you are using a SQL database, select Network connection to database server instead of File or folder in current web. Click Browse. Under Type of database driver, select SQL Server. In the Server Name field, enter the IP of the SQL Server that hosts your database, and in the Database name field, enter the name of your database. If you don't know this information, ask your host. Click OK, then click Advanced. Enter your SQL server username and password in the appropriate fields, then click OK until you are returned to the Database tab.

You should now see your new connection displayed with a ? next to it. Select the new connection by clicking on it, then click Verify, then Apply. The question mark will change to a green check mark. This will apply the database connection to your web and allow your ASP pages to communicate with the database.

Test your site again. If the error persists even after these steps have been followed, contact StoreFront Support.

If the error occurs during your web store's checkout process, make sure that your DSN has been entered into the db.conn.open.asp file that resides in the SSL/SFLib folder of your site's secure location. You can find information describing how to do this in Step 6 of the StoreFront help files.

STOREFRONT FOR DREAMWEAVER/DREAMWEAVER ULTRADEV

Open your web in the Site window of Dreamweaver or UltraDev.

Click on the StoreFront menu and select Web Database Connection.

Select your development environment: live or local.

StoreFront supports five different database connection methods. All the connection methods achieve the same end result; the choice is a matter of personal preference. We recommend using the Access File in Current Web option for all stores using an Access database. For stores using a SQL Server database, we recommend the Network Connection to Database Server method.

To connect to an Access database: select Access File in Current Web, then click Browse. Browse to the location of the Access database file in your web store (by default, this will be the StoreFront.mdb in the fpdb folder. After selecting the file, click OK. Click Apply. If you are configuring this connection for a remote web store, be sure to upload your local site's global.asa file to the remote server.

To connect to a SQL Server database: select Network Connection to Database Server, then click Browse. Enter the name or IP address of your SQL Server in the Server name or IP address field. Enter the name of your web store's database in the Database Name field. Enter your SQL Server username and password in the User Name and Password fields. Click Test. If the test succeeds, click OK, then click Apply. Upload your global.asa file to the remote site. If the test does not succeed, review your connection information and try again.

Browse more...
StoreFront 2000 Knowledge Base