Can someone please help before I go stark, raving mad?!
I'm trying to query an access database through an asp page. I've set up a test at our home page on Our .asp and .inc files are in a sub-folder called "database" and our database is in the "private" folder, where it should be according to our host. Clicking through to the .asp page gives the following error:
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 0xea4 Thread 0xbd4 DBC 0x29a67e4 Jet'.
/database/wed_asp_odbc.inc, line 415
Apparently this is a problem with the DBQ statement. Here is the relevant section from the .inc file:
Set Conn = Server.CreateObject("ADODB.Connection"
conString = "DBQ=" & Server.MapPath("\scotsinfo\private\test.mdb"
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & conString
set cursor = server.CreateObject("adodb.recordset"
cursor.cursortype = WED_CURSOR_TYPE
cursor.open sqlstr, Conn
I've tried every combination in the \scotsinfo\private\test.mdb path - no username, back slashes, forward slashes, you name it. Still I get similar error messges and am finally at a loss as to what to do next. Any help would be greatly appreciated.
I'm trying to query an access database through an asp page. I've set up a test at our home page on Our .asp and .inc files are in a sub-folder called "database" and our database is in the "private" folder, where it should be according to our host. Clicking through to the .asp page gives the following error:
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 0xea4 Thread 0xbd4 DBC 0x29a67e4 Jet'.
/database/wed_asp_odbc.inc, line 415
Apparently this is a problem with the DBQ statement. Here is the relevant section from the .inc file:
Set Conn = Server.CreateObject("ADODB.Connection"
conString = "DBQ=" & Server.MapPath("\scotsinfo\private\test.mdb"
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & conString
set cursor = server.CreateObject("adodb.recordset"
cursor.cursortype = WED_CURSOR_TYPE
cursor.open sqlstr, Conn
I've tried every combination in the \scotsinfo\private\test.mdb path - no username, back slashes, forward slashes, you name it. Still I get similar error messges and am finally at a loss as to what to do next. Any help would be greatly appreciated.