Am I understanding correctly that you are connecting and disconnecting during each pass through the loop (for each record)?
If so, You may simply be overwhelming the server with connections.
Connect before starting the loop, run through all records, and disconnect. your server and your network will thank you!
>I have a VFP9 application that runs nightly. This app SCANs through a DBF, gets the customer number, connects to our SQL Server to search for the customer, then either UPDATEs or INSERTs the record into the SQL Server table and then disconnects.
>
>The routine will establish a connection SQLConnect(DSN,UID,Password) at the beginning of the loop and SQLDisconnect(nHandle) at the end of the loop.
>
>Lately, the routine has been logging the following SQL error:
> 1526
> SQL Server does not exist or access denied.
>
>These errors occur approximatley every 1900 times thru the loop.
>
>What causes this error to occur?
>
>Thanks,
>
>Jerry
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________