Hi Dorin,
Maybe is bug in VFP, maybe in ODBC manager/driver.
If you downgrade MDAC to version 2.5/2.1, You haven't problems.
Or you can before calling REQUERY(), REFRESH(), SQLEXEC(), SQLPREPARE() etc. call SQLGETPROP() with TRY/CATCH/FINALY, and second calling restoring ODBC connection from VFP to ODBC driver.
MartinJ
>Hi all
>
>I have trouble with reconnection after a SQLIdleDisconnect() or when the IdleTimeout interval elapsed for a ODBC connection to a Firebird server.
>I discussed with ODBC driver developer and seems that VFP send a truncated connection string necessary for reconnection. The driver has many connection parameter and exceed the lenght used by VFP.
>
>Is this a bug or the normal behavior ?