2. ASPRunnerPro General questions
  3. 80004005
This topic is locked

80004005

 		7/6/2006 10:51:46
ASPRunnerPro General questions
R
 roller author

My code works fine on a local server and with one service provider. With another service provider however I get the following error when I try to login:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/reports67/login.asp, line 69
which is
set dbConnection = server.CreateObject("ADODB.Connection")

dbConnection.ConnectionString = strConnection

dbConnection.Open

Call ReportError
Why does it work in one place and not another?
Sergey Kornilov admin 7/6/2006

Post your connection string here. Connection string can be found in include/dbconnection.asp file.
R
 		roller author 7/6/2006

Thank you for help. Here is the connection string:
<%

strConnection = "DBQ=" & server.mappath("db\GradePassword.mdb") & ";Driver={Microsoft Access-Treiber (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

%>
Alexey admin 7/7/2006

Hi,
try to modify your dbconnection.asp file this way:

<%

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

%>



then upload it to your server.
R
 		roller author 7/7/2006

Thanks that worked great.
If you have time I'd like to know why the original wasn't like that and why it worked on another server.
Alexey admin 7/10/2006

Hi,
it didn't work because the German version of Access driver was not installed on the server.