Unable to Open ODBC Registry Key

[GrahamC]

Hi:

Using MS Access in a server-side application (Win2k Adv.
Server, IIS 6, ASP) we suddenly are getting the following
error on most pages:

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 0x5fc Thread 0x11c DBC 0xc79014 Jet'.

This happens trying to open a database using a File DSN,
such as:

Set cnnActive = Server.CreateObject("ADODB.Connection")
cnnActive.Open = "FILEDSN = c:\.....\Active.dsn","admin,""

We checked the various knowledge base articles which all
point to a permissions problem in the registry at:

HKEY_LOCAL_MACHINE/Software/ODBC

but the permissions appear to be correct on both
workstation and server.

Could the problem be linked to setting a database
connection with the same name to nothing in previous
pages, such as:

Set cnnActive = Nothing

Any suggestions?

Thanks.

[Ray at]

Don't use a file dsn. Use an OLE DB connection string from
[url]www.connectionstrings.com[/url]. If you must stick with your ODBC usage, give
IUSR write permissions on %temp% (system, not user variable). I believe
that can be a cause of this issue.

Ray at work

"GrahamC" <grahamc@inetix.com> wrote in message
news:048e01c37706$83af51c0$a101280a@phx.gbl...

> Hi:
>
> Using MS Access in a server-side application (Win2k Adv.
> Server, IIS 6, ASP) we suddenly are getting the following
> error on most pages:
>
> 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 0x5fc Thread 0x11c DBC 0xc79014 Jet'.
>
> This happens trying to open a database using a File DSN,
> such as:
>
> Set cnnActive = Server.CreateObject("ADODB.Connection")
> cnnActive.Open = "FILEDSN = c:\.....\Active.dsn","admin,""
>
> We checked the various knowledge base articles which all
> point to a permissions problem in the registry at:
>
> HKEY_LOCAL_MACHINE/Software/ODBC
>
> but the permissions appear to be correct on both
> workstation and server.
>
> Could the problem be linked to setting a database
> connection with the same name to nothing in previous
> pages, such as:
>
> Set cnnActive = Nothing
>
> Any suggestions?
>
> Thanks.
>

[Aaron Bertrand - MVP]

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




"GrahamC" <grahamc@inetix.com> wrote in message
news:048e01c37706$83af51c0$a101280a@phx.gbl...

> Hi:
>
> Using MS Access in a server-side application (Win2k Adv.
> Server, IIS 6, ASP) we suddenly are getting the following
> error on most pages:
>
> 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 0x5fc Thread 0x11c DBC 0xc79014 Jet'.
>
> This happens trying to open a database using a File DSN,
> such as:
>
> Set cnnActive = Server.CreateObject("ADODB.Connection")
> cnnActive.Open = "FILEDSN = c:\.....\Active.dsn","admin,""
>
> We checked the various knowledge base articles which all
> point to a permissions problem in the registry at:
>
> HKEY_LOCAL_MACHINE/Software/ODBC
>
> but the permissions appear to be correct on both
> workstation and server.
>
> Could the problem be linked to setting a database
> connection with the same name to nothing in previous
> pages, such as:
>
> Set cnnActive = Nothing
>
> Any suggestions?
>
> Thanks.
>

[Mario b.]

Hi

Check your web directory security.


"GrahamC" <grahamc@inetix.com> wrote in message
news:048e01c37706$83af51c0$a101280a@phx.gbl...

> Hi:
>
> Using MS Access in a server-side application (Win2k Adv.
> Server, IIS 6, ASP) we suddenly are getting the following
> error on most pages:
>
> 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 0x5fc Thread 0x11c DBC 0xc79014 Jet'.
>
> This happens trying to open a database using a File DSN,
> such as:
>
> Set cnnActive = Server.CreateObject("ADODB.Connection")
> cnnActive.Open = "FILEDSN = c:\.....\Active.dsn","admin,""
>
> We checked the various knowledge base articles which all
> point to a permissions problem in the registry at:
>
> HKEY_LOCAL_MACHINE/Software/ODBC
>
> but the permissions appear to be correct on both
> workstation and server.
>
> Could the problem be linked to setting a database
> connection with the same name to nothing in previous
> pages, such as:
>
> Set cnnActive = Nothing
>
> Any suggestions?
>
> Thanks.
>

[GrahamC]

Thanks to all; we did in fact switch to a OLE string and
it it both solved the issue and improved database
connectivity.

For others interested, we switched from:

Set cnnActive = Server.CreateObject ("ADODB.Connection")
cnnActive.Open "FILEDSN=c:\<dsn
path>\active.dsn","admin",""

to:

strOLEDB = "Provider=Microsoft.Jet.OLEDB.4.0;"
strOLEDB = strOLEDB & "Data Source=C:\<database
path>\active.mdb;"
strOLEDB = strOLEDB & "User ID=admin;Password=;"

Set cnnActive = Server.CreateObject ("ADODB.Connection")
cnnActive.Open strOLEDB

Thanks again.

>-----Original Message-----
>Hi:
>
>Using MS Access in a server-side application (Win2k Adv.
>Server, IIS 6, ASP) we suddenly are getting the following
>error on most pages:
>
>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 0x5fc Thread 0x11c DBC 0xc79014 Jet'.
>
>This happens trying to open a database using a File DSN,
>such as:
>
>Set cnnActive = Server.CreateObject("ADODB.Connection")
>cnnActive.Open = "FILEDSN = c:\.....\Active.dsn","admin,""
>
>We checked the various knowledge base articles which all
>point to a permissions problem in the registry at:
>
>HKEY_LOCAL_MACHINE/Software/ODBC
>
>but the permissions appear to be correct on both
>workstation and server.
>
>Could the problem be linked to setting a database
>connection with the same name to nothing in previous
>pages, such as:
>
>Set cnnActive = Nothing
>
>Any suggestions?
>
>Thanks.
>
>.
>