Subject | ConnString for VFP works on and off (Connection handle is invalid.) |
---|---|
Author | Bhavbhuti Nathwani |
Post date | 2009-07-17T15:05:39Z |
Hi all
I have had my app originally based on ODBC connection to the FB database and that was fine. Since recently I have converted the same app to use ConnString internally from the app. The ConnString is something like this:
Driver={Firebird/InterBase(r) driver};Dbname=DEVE2:C17_32167;PWD=masterkey;UID=SYSDBA
Now every so often that app that works from my computer to access remote data using the ConnString will stop working raising the error in VFP as 1466: Connection handle is invalid. Then sometime later I try the same app and it will work again.
I am sure I am missing something but do not know nor can find a pattern when it happens. Please shed some light if this is something that others have encountered and resolved.
Thanks and regards
Bhavbhuti
I have had my app originally based on ODBC connection to the FB database and that was fine. Since recently I have converted the same app to use ConnString internally from the app. The ConnString is something like this:
Driver={Firebird/InterBase(r) driver};Dbname=DEVE2:C17_32167;PWD=masterkey;UID=SYSDBA
Now every so often that app that works from my computer to access remote data using the ConnString will stop working raising the error in VFP as 1466: Connection handle is invalid. Then sometime later I try the same app and it will work again.
I am sure I am missing something but do not know nor can find a pattern when it happens. Please shed some light if this is something that others have encountered and resolved.
Thanks and regards
Bhavbhuti