Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    911
    Thanks
    302
    Thanked 2 Times in 2 Posts

    Question Microsoft Excel Driver Error

    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.


    Code:
    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:

    Code:
    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\"

  • #2
    Regular Coder
    Join Date
    Jan 2005
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts
    try using OLE driver instead of ODBC driver.

    http://www.connectionstrings.com/?carrier=excel


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •