2. ASPRunnerPro General questions
  3. [SOLVED]  Excel or CSV File Import Fails
This topic is locked
[SOLVED]

 Excel or CSV File Import Fails

 		7/28/2010 5:44:45 PM
ASPRunnerPro General questions
M
 mnegrete author

When trying to use the "import" feature to import an Excel or CSV file, we receive an IIS Error 500. The file appears in the "tmp" dir but the import fails. We are using ASPRunner 6.1, IIS7 and SQL Server 2008 on a Windows2008 server.
Checked already:

  1. Ensure application has write permission to "tmp" dir.
  2. Set "Maximum Requesting Entity Body Limit" to 3000000
  3. Made sure Excel files are version 2003
    This is the specific error:
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Driver] Data source name not found and no default driver specified

    /CDIPweb/DRGMaster_import.asp, line 48
    This is line 47 and 48:

    strConn = "DRIVER={Microsoft Excel Driver (*.xls)};UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;ReadOnly=1;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=excel 8.0;DriverId=790;DBQ=" & psFilePath

    dbConn.Open strConn
    Any suggestions would be greatly appreciated as we are in the middle of an on-site customer installation.
A
 		ann 7/29/2010

Michael,
make sure you setup write permissions for web server user on temporary folder where Excel file is uploaded.
M
 		mnegrete author 7/29/2010



Michael,
make sure you setup write permissions for web server user on temporary folder where Excel file is uploaded.


If you completely read my post, I've already done that. Its item 1. ~Michael
M
 		mnegrete author 7/29/2010

PROBLEM SOLVED!
We had moved from a 32bit Windows2008 server to a 64bit Windows2008 server.
32 bit DLL's (ODBC Drivers used for xls and csv imports) won't load into a 64 bit process. To do this you need to configure the application pool for your ASPRunner app to run in 32 bit mode. (We create dedicated pools for each of our apps.) You can configure this in the "Advanced Settings" of the application pool. Set Enable 32-Bit Applications to "True".
~Michael