Microsoft Excel Driver Error

Discussion in 'C#' started by cancer10, Jan 23, 2007.

0
  1. #1
    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.


    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
    Code (markup):
    FYI, I am using the following connection string:

    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\"
    Code (markup):
     
    cancer10, Jan 23, 2007 IP
  2. intothemiddle

    intothemiddle Peon

    Messages:
    49
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    This problem is caused by using an old ODBC driver.

    http://www.aspfaq.com/show.asp?id=2154

    Try switching to using the Jet OLE DB provider per this:
    http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJetExcel

    Hope that helps.

    [ http://www.issociate.de/board/post/311110/Microsoft%5D%5BODBC_Excel_Driver%5DGeneral_error_Unable_to_open_registry_key_'Temporary_(volatile)_Jet_DSN.html ]
     
    intothemiddle, Jan 23, 2007 IP