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.