I'm receiving this error. Is this due to memory?

Err No: 17 :[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access denied.;

It happens if the loop gets larger than a certain number of loop iterations.
The magic number is somewhere between 2,000 and 2,400. For example, the file
with 2,000 rows is being processed without errors, and the file with 2,400
rows blows up. It’s not dependent on the data. We tried creating files in
different ways, and it really has only to do with the number of loop
iterations

"Hoby1Cat" <Hoby1Cat@discussions.microsoft.com> wrote in message
news:3EB133E1-821C-4EE3-91C5-14B657CEF68C@microsoft.com...
> I'm receiving this error. Is this due to memory?
>
> Err No: 17 :[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
> exist
> or access denied.;
>
> It happens if the loop gets larger than a certain number of loop
> iterations.
> The magic number is somewhere between 2,000 and 2,400. For example, the
> file
> with 2,000 rows is being processed without errors, and the file with 2,400
> rows blows up. It's not dependent on the data. We tried creating files in
> different ways, and it really has only to do with the number of loop
> iterations
>

Does each loop open another connection to SQL Server? Are you using
connection pooling in your application?

SQL Server is SET based, you may wish to reconstruct your code to use SETS
instead of row-by-row logic.

These are just a couple of guesses off the top of my head.


Rick Sawtell