General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error when connecting to SQl Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only