Networks

Ask something
Discussion Locked

IIS can't open ODBC with Jscript

0 helpful
4 replies

by dryflies

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I get the following error when attempting to query an Access DB using a script:

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 0x1d0 Thread 0x6a8 DBC 0x2342024 Jet'.
/quickgraph.asp, line 28

I have looked in technet for a solution but The solution did not help when implemented. The line referenced is a conn.Open statement. The script worked before we did a reinstall of w2k server. Now we get the error. Am I missing a configuration item?

4 replies

by vinnyd

Sounds like you do not have the correct Data Access Objects (dao) loaded.

Download dao 2.5 or higher from microsoft and install it.

by shawn

I had the same issue, the following article helped me out with getting it resolved:(remove any spaces)

http://www.attention-to-details.com/newslog/38n-temporary-volatile-jet-dsn-for-process.asp

Hope this helps.

Cheers,
Shawn

by dryflies

This answer covers the problem. it was the IUSR_.. account did not have write permissions for the DB. Even though it was only querying the DB and not updating.

This discussion is closed to new replies.