Error while trying to connect to Access database within ASP

[Terry Murray]

I am getting an error message while trying to connect to an Access database
within ASP. This error only occurs on my notebook computer and not on my
desktop computer. I am running from within the same environment. That is,
the same versions of Access and IIS. If anyone could help me I would really
appreciate it because I enjoy having the ability to develop from my
notebook.

The error message is:

The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot
be displayed.


--------------------------------------------------------------------------

Please try the following:

a.. Click the Refresh button, or try again later.
b.. Open the localhost home page, and then look for links to the
information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------

Technical Information (for support personnel)

a.. 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 0x10c Thread
0x4bc DBC 0x109a024 Jet'.
/wcg/games.asp, line 336
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
c.. Page:
GET /wcg/games.asp
d.. Time:
Wednesday, December 03, 2003, 7:31:10 PM
e.. More information:
Microsoft Support



Thanks



Terry

[Ray at]

This is most likely caused by your IUSR account not having write/modify
permissions on the %temp% directory. You can avoid this by changing your
connection to an OLEDB connection instead of the old technology ODBC. Get
your OLEDB connection string for Access at [url]www.connectionstrings.com[/url].

Ray at work

"Terry Murray" <tgmurray@rogers.com> wrote in message
news:sBqBb.23192$r%u1.6648@twister01.bloor.is.net. cable.rogers.com...

> I am getting an error message while trying to connect to an Access

database

> within ASP. This error only occurs on my notebook computer and not on my
> desktop computer. I am running from within the same environment. That is,
> the same versions of Access and IIS. If anyone could help me I would

really

> appreciate it because I enjoy having the ability to develop from my
> notebook.
>
> The error message is:
>
> The page cannot be displayed
>
> There is a problem with the page you are trying to reach and it

cannot

> be displayed.
>
>
> --------------------------------------------------------------------------
>
> Please try the following:
>
> a.. Click the Refresh button, or try again later.
> b.. Open the localhost home page, and then look for links to the
> information you want.
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> --------------------------------------------------------------------------
>
> Technical Information (for support personnel)
>
> a.. 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 0x10c Thread
> 0x4bc DBC 0x109a024 Jet'.
> /wcg/games.asp, line 336
> b.. Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
> c.. Page:
> GET /wcg/games.asp
> d.. Time:
> Wednesday, December 03, 2003, 7:31:10 PM
> e.. More information:
> Microsoft Support
>
>
>
> Thanks
>
>
>
> Terry
>
>

[Aaron Bertrand - MVP]

[url]http://www.aspfaq.com/2154[/url]

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Terry Murray" <tgmurray@rogers.com> wrote in message
news:sBqBb.23192$r%u1.6648@twister01.bloor.is.net. cable.rogers.com...

> I am getting an error message while trying to connect to an Access

database

> within ASP. This error only occurs on my notebook computer and not on my
> desktop computer. I am running from within the same environment. That is,
> the same versions of Access and IIS. If anyone could help me I would

really

> appreciate it because I enjoy having the ability to develop from my
> notebook.
>
> The error message is:
>
> The page cannot be displayed
>
> There is a problem with the page you are trying to reach and it

cannot

> be displayed.
>
>
> --------------------------------------------------------------------------
>
> Please try the following:
>
> a.. Click the Refresh button, or try again later.
> b.. Open the localhost home page, and then look for links to the
> information you want.
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> --------------------------------------------------------------------------
>
> Technical Information (for support personnel)
>
> a.. 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 0x10c Thread
> 0x4bc DBC 0x109a024 Jet'.
> /wcg/games.asp, line 336
> b.. Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
> c.. Page:
> GET /wcg/games.asp
> d.. Time:
> Wednesday, December 03, 2003, 7:31:10 PM
> e.. More information:
> Microsoft Support
>
>
>
> Thanks
>
>
>
> Terry
>
>

[Terry Murray]

Thanks for the quick response Ray. I have not tried what you suggested yet
but I thought that I should also let you know that the error goes away
temporarily if I reboot. Eventually, though, it rears its ugly head again.
If I understand you correctly all I have to do is use connection code
similar to this:

<%
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
cst = cst & server.mappath("/<pathtofile.mdb>")
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst
%>

I imagine that I still require an ODBC Dsn. In the past I was choosing to
use a file DSN.

Thanks again
Terry

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:eknYHbpvDHA.3416@tk2msftngp13.phx.gbl...

> This is most likely caused by your IUSR account not having write/modify
> permissions on the %temp% directory. You can avoid this by changing your
> connection to an OLEDB connection instead of the old technology ODBC. Get
> your OLEDB connection string for Access at [url]www.connectionstrings.com[/url].
>
> Ray at work
>
> "Terry Murray" <tgmurray@rogers.com> wrote in message
> news:sBqBb.23192$r%u1.6648@twister01.bloor.is.net. cable.rogers.com...

> > I am getting an error message while trying to connect to an Access

> database

> > within ASP. This error only occurs on my notebook computer and not on my
> > desktop computer. I am running from within the same environment. That

is,

> > the same versions of Access and IIS. If anyone could help me I would

> really

> > appreciate it because I enjoy having the ability to develop from my
> > notebook.
> >
> > The error message is:
> >
> > The page cannot be displayed
> >
> > There is a problem with the page you are trying to reach and it

> cannot

> > be displayed.
> >
> >

>
> --------------------------------------------------------------------------

> >
> > Please try the following:
> >
> > a.. Click the Refresh button, or try again later.
> > b.. Open the localhost home page, and then look for links to the
> > information you want.
> > HTTP 500.100 - Internal Server Error - ASP error
> > Internet Information Services
> >

>
> --------------------------------------------------------------------------

> >
> > Technical Information (for support personnel)
> >
> > a.. 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 0x10c Thread
> > 0x4bc DBC 0x109a024 Jet'.
> > /wcg/games.asp, line 336
> > b.. Browser Type:
> > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
> > c.. Page:
> > GET /wcg/games.asp
> > d.. Time:
> > Wednesday, December 03, 2003, 7:31:10 PM
> > e.. More information:
> > Microsoft Support
> >
> >
> >
> > Thanks
> >
> >
> >
> > Terry
> >
> >

>
>

[Aaron Bertrand - MVP]

> <%

> cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> cst = cst & server.mappath("/<pathtofile.mdb>")
> set conn = Server.CreateObject("ADODB.Connection")
> conn.open cst
> %>
>
> I imagine that I still require an ODBC Dsn. In the past I was choosing to
> use a file DSN.

No, the whole point of using the connection string above is to avoid ODBC
and DSNs altogether.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]