2. ASPRunnerPro General questions
  3. Export failing when large number of records +2000 attempted.
This topic is locked

Export failing when large number of records +2000 attempted.

 		4/1/2011 2:08:07 PM
ASPRunnerPro General questions
S
 swiersman author

Hello...,
When exporting a large number of records (2000+) through a web interface built using ASP RUNNER(Version 6.1) the request is failing because all available unassigned TCP ports are being used. When viewing NETSTAT on the MS Windows 2003 IIS server there are 4000 + sockets in TCP TIME_WAIT status connected to our MS SQL 2008 DB on MS 2003 Server.

If you could suggest a fix for this or a known limitation we would appreciate it greatly.
Thanks,
Scott
Sergey Kornilov admin 4/1/2011

Just in case make sure your export page doesn't include lookup wizard fields. If yes, try to remove lookup wizard fields from the export page or re-write your SQL Query to pull values from joined tables (as opposed to using lookup wizard).
Let me know if this makes sense.
S
 		swiersman author 4/4/2011

The application we are exporting from only has a view page. All fields are set to text fields in the settings.asp configuration.
The specific error returned is below.
Microsoft SQL Server Native Client 10.0 error '80004005'

TCP Provider: Only one usage of each socket address (protocol/network address/port) is normally permitted.

/admin_view/include/aspfunctions.asp, line 1152
Please help...
Thanks,
Scott
Sergey Kornilov admin 4/5/2011

Scott,
I would suggest 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.