1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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