2. ASPRunnerPro General questions
  3. db connection
This topic is locked

db connection

 		9/28/2004 2:12:51 PM
ASPRunnerPro General questions
author

My isp requires all databases to be located in one folder called databases.
Currently my asp pages have this
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "A3736_teamblcZip"
What do I have to do to set-up my new files to connect to this database?
Thank you

Gregg
Sergey Kornilov admin 9/30/2004

Gregg,
I would recommend to create ASP code using your local database copy.

By default ASPRunner generates connection string like this:
strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver

(.mdb)};DBQ=" & server.mappath("db\yourdatabase.mdb") & ";UID=;PWD="
Before uploading files to the Web server you need to modify connection

string to point to DATABASES folder like this:
strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver

(.mdb)};DBQ=" & server.mappath("..\..\databases\yourdatabase.mdb") & ";UID=;PWD="
Actual connection string can be slightly different. It depends on

where you put ASP files generated by ASPRunner.