2. ASPRunnerPro General questions
  3. Excel and -2147467259
This topic is locked

Excel and -2147467259

 		4/19/2004 4:24:43 PM
ASPRunnerPro General questions
author

I'm getting the following error:
Error number: -2147467259
Description: [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7b4 Thread 0x9ac DBC 0x261e24c Excel'.
Here is the connection:
<%

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Excel Driver (*.xls)};DBQ=\\sourus\Departments\Sales\Management Docs\Deal Tracking\Sales Tracking.xls;UID=;PWD=;Readonly=True;"

%>
Sergey Kornilov admin 4/20/2004

Jason,
there are two possible reasons thay may cause this error message:

  1. Excel file is open in MS Excel when you trying to run this ASP page
  2. IUSR_... user (that ASP engine uses) don't have rights to access this network share. Try to copy this file to your local drive and test again.