Server.MapPath

DB = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("\db\CDLData.mdb")

I am trying to connect to an Access DB which is stored in sub-directory of
the directory in which the asp file is stored. The string above gives the
following 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 0x13c Thread 0x81c
DBC 0x250377c Jet'.

What am I doing wrong?

When the db is in the same directory and the '\db\' is removed everythign
works fine.

Re: Server.MapPath

Paul Smith wrote on 01 jan 2005 in microsoft.public.inetserver.asp.db:

> Server.MapPath("\db\CDLData.mdb")

Server.MapPath("/db/CDLData.mdb")

> Driver={Microsoft Access Driver (*.mdb)};

Better use, I think:

set CONNECT = server.CreateObject("ADODB.Connection")
CONNECT.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("/db/CDLData.mdb") & ";"


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Re: Server.MapPath

"Paul Smith" wrote in message
news:41d70f20$0$74239$ed2619ec@ptn-nntp-reader03.plus.net...
> DB = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("\db\CDLData.mdb")
>
> I am trying to connect to an Access DB which is stored in sub-directory of
> the directory in which the asp file is stored. The string above gives the
> following 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 0x13c Thread 0x81c
> DBC 0x250377c Jet'.
>
> What am I doing wrong?
>
> When the db is in the same directory and the '\db\' is removed everythign
> works fine.

What happens if you lose the leading backslash from the path
(db\CDLData.mdb) or fully-qualify the path
(C:\Inetpub\wwwroot\db\CDLData.mdb)?

Re: Server.MapPath

On Sat, 1 Jan 2005 20:59:15 -0000, "Paul Smith"
wrote:

>DB = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &
>Server.MapPath("\db\CDLData.mdb")

Server.MapPath uses forward slashes, though thta's not the error
you're receiving.

Server.MapPath("/db/CDLData.mdb")

>I am trying to connect to an Access DB which is stored in sub-directory of
>the directory in which the asp file is stored. The string above gives the
>following 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 0x13c Thread 0x81c
>DBC 0x250377c Jet'.

Registry key permission error. See:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

>What am I doing wrong?

Access databases need the registry key permission set correctly, as
well as at least Modify permission for the users, normally the
Anonymous Web User, accessing the MDB file in the folder the MDB file
is in.

Jeff

Re: Server.MapPath

> Access databases need the registry key permission set correctly

Though that part of the problem will go away when you use the JET/OLEDB
driver instead of the MDB driver...

--
http://www.aspfaq.com/
(Reverse address to reply.)

Re: Server.MapPath

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Re: Server.MapPath

Rajgupta Gupta wrote on 10 jan 2005 in microsoft.public.inetserver.asp.db:

> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an
> updateable query.
>

Please quote where you are replying on.

This is usenet, not email.


--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

Re: Server.MapPath

Rajgupta Gupta wrote:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an
> updateable query.

http://www.aspfaq.com/show.asp?id=2062
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"