How do I set Database Connection on GoDaddy server?

21 Nov 2009

Support Center » Knowledgebase » How do I set Database Connection on GoDaddy server?

	How do I set Database Connection on GoDaddy server?

Solution

Q: How do I set Database Connection on GoDaddy server?

A:
GoDaddy recommends that you to move your Access Database to "access_db" folder on your root since it already has the correct permission.
In order to get the application working you need to change the connection string inside the application.

Follow these steps to change the connection string:

Move your the database from "databases" folder to "access_db" folder.
Open the connection string file. The file will be in form of the product name in low case.
e.g.: SecureLoginManager :: Open: "/Connections/secureloginmanager.asp"
Locate the following line:
MM_secureloginmanager_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/databases/SecureLoginManager.mdb") & ";"
Change that line to:
MM_secureloginmanager_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/access_db/SecureLoginManager.mdb") & ";"
Save the file
Upload it to the server