PDA

View Full Version : Database error..

Mhtml
10-10-2002, 08:59 AM
I'm getting this error
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 0x684 Thread 0x714 DBC 0x175e274 Jet'.
/projectodyssey/list/emailvalidator.asp, line 8

Here is line 8 the database is in the directory "db" off the root and this file the error is coming from is in a folder "list" off the root.

set AddConn = server.CreateObject("adodb.connection")
AddConn.open = "driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mapPath("db/odysseylist.mdb")
glenngv
10-10-2002, 10:35 AM
AddConn.open = "driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mapPath("/db/odysseylist.mdb")
Roelf
10-10-2002, 10:54 AM
i would lose the equal sign in the open statement:
AddConn.open "driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mapPath("db/odysseylist.mdb")
Mhtml
10-10-2002, 11:05 AM
I still get the same error.
glenngv
10-10-2002, 11:25 AM
AddConn.open = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mapPath("/db/odysseylist.mdb") & ";"
Roelf
10-10-2002, 11:35 AM
try:
AddConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & server.mapPath("/db/odysseylist.mdb")
Mhtml
10-10-2002, 12:34 PM
I have it working now but it has never been like this before. The connection string I showed in my frist post I have used for everything and now it wouldn't even the last snippet you gave me took a little configuring in the mappath , it kept trying to get it from c:\inetpub\db instead of my directory and then it was trying to get it from c:\inetpub\projectodyssey\list\projectodyssey\db\odysseylist.mdb

..Crazy!:confused:
Roelf
10-10-2002, 01:03 PM
now im curious, what did you have to change in the mappath bit
whammy
10-11-2002, 02:43 AM
It might have to do with your directory structure... for instance, on brinkster.com all of the databases (or for that matter, anything that has write permissions) has to be in a separate folder (called database) that's in the directory ABOVE your root folder...

So in order for me to properly map a path (on brinkster), I have to figure out the local path above the root directory which is kind of a pain, but once I figured it out just reuse the code.
Mhtml
10-11-2002, 04:37 AM
server.MapPath("../db/odysseylist.mdb")

I have always just used db/odysseylist.mdb