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-17T20:22:37Z |
I have not used it that way, but I believe that you should substitute path for aliases of the connection that I sent you.
Regards
=========
¦¦ ISMAEL ¦¦
=========
"Oír o leer sin reflexionar es una ocupación inútil".
Confucio (551-479 a. C.); filósofo chino.
----- Mensaje original -----
De: Bhavbhuti Nathwani
Para: firebird-support@yahoogroups.com
Enviado: viernes, 17 de julio de 2009 12:18
Asunto: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.)
Thanks Ismael for the response,unless I understood incorrectly, I was hoping to use Aliases as there is no way the client knows the path to where the database is located on the server. But surely the server app knows where the database is and does put it in the aliases.conf
Kind regards
Bhavbhuti
Regards
=========
¦¦ ISMAEL ¦¦
=========
"Oír o leer sin reflexionar es una ocupación inútil".
Confucio (551-479 a. C.); filósofo chino.
----- Mensaje original -----
De: Bhavbhuti Nathwani
Para: firebird-support@yahoogroups.com
Enviado: viernes, 17 de julio de 2009 12:18
Asunto: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.)
Thanks Ismael for the response,unless I understood incorrectly, I was hoping to use Aliases as there is no way the client knows the path to where the database is located on the server. But surely the server app knows where the database is and does put it in the aliases.conf
Kind regards
Bhavbhuti
--- In firebird-support@yahoogroups.com, "Ismael L. Donis García" <ismael@...> wrote:
>
> 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.
>
> --- 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]
>
[Non-text portions of this message have been removed]