DaniWeb Forum Index > Web Development > ASP

Microsoft Excel Driver Error

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2004

Posts: 234

Reputation: cancer10 is an unknown quantity at this point

Solved Threads: 0

cancer10

Offline

Posting Whiz in Training

Microsoft Excel Driver Error

Jan 23rd, 2007

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.

 Help with Code Tags 
 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:

 Help with Code Tags 
 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\"