Could you show us your code?


>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