Subject Re: ConnString for VFP works on and off (Connection handle is invalid.)
Author Bhavbhuti Nathwani
This is the exact text of the error message I get in VFP. I agree these are VFP messages but if it sheds light on the same
Error #: 1526
Message: Connectivity error: Unable to complete network request to host "DEVE2".
Failed to locate host machine.
The specified name was not found in the hosts file or Domain Name Services.
Line #: 835
Method: opentables
Object: vso3

In any case let us assume networking problem then why would it works fine using ODBC on the same network?

Please advise.

--- In firebird-support@yahoogroups.com, "Bhavbhuti Nathwani" <venussoftop@...> wrote:
>
> 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
>