Hi Martin
Thanks

>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 ?