Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process

This error occurs suddenly on my webserver ( IIS and Windows 2000 Server) ...... on ASP ......
Would somebody please help ? Thanks.

Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process



My code is as follow:

      datafile = ""
      Set rstExcel = Nothing
      Set cnnExcel = Nothing

      Set cnnExcel = Server.CreateObject("ADODB.Connection")

'      datafile = "DBQ=" & "c:\data.xls" & ";" & "DRIVER={Microsoft Excel Driver (*.xls)};"

'      cnnExcel.Open datafile


mikekwokAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Anthony PerkinsConnect With a Mentor Commented:
From these articles in MSDN, it appears to be permissions problems in your Temp folder:

PRB: Error Message: 0x80004005: General Error Unable to Open Registry Key
http://support.microsoft.com/default.aspx?scid=kb;en-us;295297

FP: Error: Unable to Open Jet Temporary Key When You Attempt to Connect to Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;315456
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.