[RESOLVED] access connection error

[ikaris69]

ok here is my connection

<%
Dim objConn
    set objConn = server.createobject("ADODB.connection")
    objConn.Open "driver={microsoft access driver (*.mdb)};" & "dbq=../../products.mdb"
%>

here is the error i get
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 0x2dbc Thread 0x2300 DBC 0xe4b1cdc Jet'.

/admin/db.inc, line 4




im not sure whey its doing this any help appreciated

[rory]

Not sure where your Database Is located but it would be something like this ..

You can do this to test your path locations from the asp page ..

Response.Write Server.Mappath("./../../")
Response.End

<%
Dim objConn
    set objConn = server.createobject("ADODB.connection")
    objConn.Open "driver={microsoft access driver (*.mdb)}; dbq=" & Server.Mappath("./../../products.mdb")
%>

Or ..

<%
Dim objConn
    set objConn = server.createobject("ADODB.connection")
    objConn.Open "driver={microsoft access driver (*.mdb)}; dbq=D:\mywebs\thisweb\database\products.mdb"
%>

[ikaris69]

oh nice let me try that.

[ikaris69]

sweet that worked i was able to get the correct path, thanks much, that info is good to know for testing too.