Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't Query Database

Status
Not open for further replies.

compuv

MIS
Mar 16, 2002
10
GB
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top