2. ASPRunnerPro General questions
  3. DB Connection String
This topic is locked

DB Connection String

 		9/13/2004 7:27:18 AM
ASPRunnerPro General questions
I
 ivan author

Hi, When I change the database location I change the DB Connection string but no matter what I do it will not work. I get the following when I try to log in. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xb1c Thread 0x900 DBC 0xe9432dc Jet'.
/custpc/admin/login.asp, line 60
Please can you help.
Regards

Ivan
PS. Great product.
Sergey Kornilov admin 9/13/2004

Ivan,
could you post your connection string here?
Also I need to know full path to the database file and to directory where ASP files reside.
I
 		ivan author 9/13/2004

Here is the connection string

<%

strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("..\..\database\pcdata.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

%>
The directory structure is

database

www\custpc\admin
admin holds the asp pages
thanks

ivan
Sergey Kornilov admin 9/13/2004

Ivan,
connection string looks just perfect.
Just in case make sure that you have updated connection string in both login.asp and include/..._dbconnection.asp. Login.asp uses it's own connection string.