Subject | Re: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.) |
---|---|
Author | Ismael L. Donis García |
Post date | 2009-07-17T17:51:07Z |
DRIVER=Firebird/InterBase(r) driver; UID=sysdba; PWD=masterkey; DBNAME=IP_Server/#_Port:path+db.fdb; CHARACTERSET=type_charset;"
=========
¦¦ ISMAEL ¦¦
=========
----- Mensaje original -----
De: Bhavbhuti Nathwani
Para: firebird-support@yahoogroups.com
Enviado: viernes, 17 de julio de 2009 10:08
Asunto: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.)
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.
=========
¦¦ ISMAEL ¦¦
=========
----- Mensaje original -----
De: Bhavbhuti Nathwani
Para: firebird-support@yahoogroups.com
Enviado: viernes, 17 de julio de 2009 10:08
Asunto: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.)
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
>
[Non-text portions of this message have been removed]