Link to home
Start Free TrialLog in
Avatar of darrensto
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.
ASKER CERTIFIED SOLUTION
Avatar of todd_farmer
todd_farmer
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial