This topic is locked

Help!!!! - -2147467259

3/2/2004 2:47:48 PM
ASPRunnerPro General questions
author

I have looked through the forum ltrying for a solution and I missed it.
I have a web store with an existing Access database. I've added few table to use with the pages I'm generating through ASPRunner.
I do not have any trouble connecting the database with my shopping cart pages.
The connection string looks like this:

<%

DIM sDSN

sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\jazzedonjava\fpdb\vsproducts.mdb;" ' Microsoft Access 2000 using mapped path

%>
I added the same code to the include/ ..._dbconnection.asp page
The Error I'm getting is:

ASP error happened

Technical information

Error number -2147467259

Error description [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

URL /autoship/autoship_login.asp
PLease help!!!!!!!

Sergey Kornilov admin 3/2/2004

Lew,
here is how ..._dbconnection.asp file should look like:

<%

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\inetpub\jazzedonjava\fpdb\vsproducts.mdb;UID=;PWD="

%>


ASPRunner won't work with OLEDB data provider.

501023 3/2/2004

Awesome.........

Worked perfectly, you're the man!