darrensto
asked on
Connection problems with FoxPro and Mysql
I am using Foxpro remote views to access a Mysql database on a remote server. Most of the time this works perfectly well. Occasionally there is a connectivity problem and after 10 seconds or so the ODBC 3.51.12 screen comes up presenting all of my connection details and wanting me to click ok to attempt reconnection. Once I do, Foxpro falls over with a connecivity error.
The problem I have is that I want to trap the error in Foxpro but it waits until I click ok or cancel on the ODBC Driver Connect screen. This is no good as I don't want this user intervention when there's a failure. I need some form of timeout from this ODBC screen so that Foxpro can fail with an error.
Thank you.
The problem I have is that I want to trap the error in Foxpro but it waits until I click ok or cancel on the ODBC Driver Connect screen. This is no good as I don't want this user intervention when there's a failure. I need some form of timeout from this ODBC screen so that Foxpro can fail with an error.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.