DSN-less Connection Issues....

[dodgyone]

I can connect fine using the full path but I cannot get it to work when using Server.MapPath. My code is as follows:

'=======================================================
'open the database using a DSN-less connection
path = Trim(Server.MapPath("/Database&quot)
conn_string = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + path + "\worklist.mdb"
Set objConn = Server.CreateObject("ADODB.Connection&quot

objConn.Open conn_string
'=======================================================

The ASP page is in the directory before the database directory so this seems correct to me!

I get the error message:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3f4 Thread 0x59c DBC 0x16a0a5c Jet'.
/intranet test/testing/worklist/index.asp, line 15

Not sure what to do/try next! Thanks....

 

[dodgyone]

I Seem to of sorted it out!

Used:

'open the database using a DSN-less connection
'path = Trim(Server.MapPath("/Database&quot)
Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/intranet test/Testing/Worklist/Database/worklist.mdb&quot & ";"

I forgot about the web directory that I created on my IIS which needed to be in the string!