ASP/SQL Data Connection Error.?

Question

I have a connection to a SQL DB via an ASP webpage. I can import a few thousand records, then I get the following error. It indicates it's losing a connection to the server, but I know there is a connection because I get some records. I have my Command.Timeout maxed, as well as my Server.Script Timeout.
Any ideas?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Answer 1

Obviously the Server exists and obviously Access is not denied since you got records. So...
Make sure you're using the SQL connection object and not the ODBC Connection object, if its a SQL SERVER DB (it's prioritised for SQL);
Next, make sure you're using a stored procedure to optimise the execution;
Next, Run a trace in SQL Profiler to see what's happening on the db side;
Next, if you're still stuck (And I know you don't want to hear this) there has to be some way to reduce the number of records you are pulling back;
Start here for info: http://support.microsoft.com/kb/306518
And if all else fails get searching on google using the error mesage.

Answer 2

Obviously the server does exist, since you got some records, so the Access Denied becomes the questionable part.

I would run the process a few times and see if it errors out on the same record every time. If so, is there something different about that record? For example, does it have a blank field where it shouldn't be null?
Or does it contain a special character like @ maybe as a typo?

My other thought is that perhaps the loop uses an integer variable as the counter and you're trying to pull more records than an integer can handle.

hope that helps