2. ASPRunnerPro General questions
  3. [SOLVED]  Import XLS error HTTP 500
This topic is locked
[SOLVED]

 Import XLS error HTTP 500

 		8/24/2011 2:07:17 PM
ASPRunnerPro General questions
V
 VORONOY author

When trying to import XLS or CSV I am getting error HTTP 500
Web Server Windows 2008 64bit

SQL Server Windows 2008R2 64bit

  • tmp directory has right permissions.
  • files is uploaded to tmp directory.
    Any ideas?
Sergey Kornilov admin 8/24/2011

Hard to tell what might it be without seeing your application and Excel/CSV file in question.
I recommend to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We also need to have a sample import file to reproduce this issue.
V
 		VORONOY author 8/25/2011



Hard to tell what might it be without seeing your application and Excel/CSV file in question.
I recommend to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We also need to have a sample import file to reproduce this issue.


Hi Sergey,
I uploaded project to Demo site and it works perfect.
I think the problem I am having is servers setup.

  • They all 64bits.(tried to enable 32bit mode in AppPool, but all pages just stop working)
  • SQL and IIS on different boxes
    Thank you.
Sergey Kornilov admin 8/25/2011

Looks like server setup issue to me.
If you need more help - contact support directly. Not sure what else we can do without having a physical access to the server.
V
 		VORONOY author 8/25/2011

I was able to make it work on 64bit box.
Here is the steps:

  1. Download and install on IIS "Microsoft Access Database Engine 2010"
  2. Replace strConn in "import_functions.asp" with
    strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & psFilePath & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";"