< The Ultimate Dreamweaver Shopping Cart > Works With Any Website Design! Bookmark and Share
Site Store Professional : Dreamweaver Shopping Cart
 
Home>Knowledge Base>~ Installation (Local Files & Hosting Account)>Why do i receive an ASP error message after installing site Store Professional when trying to access the site (store files) or administration area?
Information
Article ID25
Created On1/7/2009
Modified1/7/2009
Why do i receive an ASP error message after installing site Store Professional when trying to access the site (store files) or administration area?

Your MS SQL server connection information (string) is invalid or has not been changed from the SiteStorePro installation default values if you receive the error message below:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][DBNETLIB SQL Server does not exist or access denied.

You need to change the username or password information in the SiteStoreProDB.asp file located in the Connections Folder of your Site Store Professional Installation to match your SQL server login information.

The values in RED need to be replaced with the values provided by your webhosting company or the values of your local or collocated MS SQL server database.

The following values need to be entered to connect to your specific MS SQL Database.

server = The servername or IP Address of your MS SQL Server
uid = The username provided by your webhost or entered when setting up the database
pwd = The password provided by your webhost or entered when setting up the database
database = The name of the database provided by your webhost or entered when setting up the database.

 "driver={SQL Server};server=SERVERNAME;uid=USERNAME;pwd=PASSWORD;database=DATABASE_NAME"

If you need additional assistance setting the correct MS SQL connection string for your SiteStorePro installation, please submit a trouble ticket and will be glad to help you set the correct values in the SQL Server connection string.