Microsoft Excel Driver Error

Expand Post »

Hello All,

I am using an ASP script on my site that reads a microsoft excel file and adds the values to the database (MS SQL Server). The script works completely fine on my LOCAL server, but it shows me the following error when I upload it to the server and try to run it.

ASP Syntax (Toggle Plain Text)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
 
[Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1128 Thread 0x2268 DBC 0xd2d0fec Excel'.
 
/Bacardi/bblcontest/readexcel.asp, line 5
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1128 Thread 0x2268 DBC 0xd2d0fec Excel'.

/Bacardi/bblcontest/readexcel.asp, line 5

FYI, I am using the following connection string:

ASP Syntax (Toggle Plain Text)
Set oConn = Server.CreateObject("ADODB.connection") 
oConn.Open "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790;" &_ 
"DBQ=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "upload-data\excel.xls;" &_ 
"DefaultDir = " &  Request.ServerVariables("APPL_PHYSICAL_PATH") & "upload-data\"
 
Set oConn = Server.CreateObject("ADODB.connection") 
oConn.Open "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790;" &_ 
"DBQ=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "upload-data\excel.xls;" &_ 
"DefaultDir = " &  Request.ServerVariables("APPL_PHYSICAL_PATH") & "upload-data\"

Similar Threads

Retriving data from excel sheet into an asp page in ASP
Error java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle in Java
Reading excel data using vb 6.0 in Visual Basic 4 / 5 / 6
Using Microsoft Excel 10.0 Libary Object -Dang .dlls in C#
Export Data From Excel to ASP and SQL Server in C++

cancer10

Reputation Points: 58

Solved Threads: 1

Posting Whiz in Training

Offline

234 posts
since Dec 2004

Permalink

Jan 24th, 2007

Re: Microsoft Excel Driver Error

This Article May Help You

http://access.databases.aspfaq.com/w...-driverid.html

katarey

Reputation Points: 39

Solved Threads: 23

Junior Poster

Offline

167 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: How to continue to next new excel worksheet

Next Thread in ASP Forum Timeline: No Error, No Insert: ASP to Access

DaniWeb Message

Cancel Changes

User Name
Password