Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5307
  • Last Modified:

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


0
mikekwok
Asked:
mikekwok
1 Solution
 
Anthony PerkinsCommented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now