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