2. ASPRunnerPro General questions
  3. Still having problems accessing database
This topic is locked

Still having problems accessing database

 		2/28/2005 9:38:31 PM
ASPRunnerPro General questions
L
 ligray author

I have made some progress, but his is what I am getting now:
ASP error happened

Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x11e0 Thread 0x1d40 DBC 0x1569024 Jet'.

SQL query select [Client Number], [First Name], [Middle Initital], [Last Name], [Street Address 1], [Street Address 2], [Apartment Number], [City], [State], [Zipcode], [Telpehone Number], [Email Address], [Position Desired] From [Resume Data]
Thanks a lot.
Stephen Hartman
Sergey Kornilov admin 3/1/2005

This error usually means database connection problem. Do you test it on your local box or on the remote Web server?
Post your connection string here that can be found in include/..._dbconnection.asp file.
L
 		ligray author 3/1/2005

Hello Sergey -
Here is the resume data dbconnection.asp
<%

strConnection = "Provider=MSDataShape;DBQ=C:\Program Files\ASPRunnerPro\Output\db\resumedata.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

%>
Thanks for helping me out here.
Stephen Hartman
Sergey Kornilov admin 3/2/2005

Stephen,
it appears that connection string points to the file on your local drive. I would reccomend to use Server.Mappath option while you're connecting to your database.