Subject | Re: ConnString for VFP works on and off (Connection handle is invalid.) |
---|---|
Author | Bhavbhuti Nathwani |
Post date | 2009-07-17T17:42:02Z |
Okay, thanks, I will try that and keep you posted.
Kind regards
Bhavbhuti
Kind regards
Bhavbhuti
--- In firebird-support@yahoogroups.com, Kanka sumatra <javakqj@...> wrote:
>
> Can you try using ip address instead of the host name. This looks like to me a DNS issue.
>
> --- On Fri, 7/17/09, Bhavbhuti Nathwani <venussoftop@...> wrote:
>
> From: Bhavbhuti Nathwani <venussoftop@...>
> Subject: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.)
> To: firebird-support@yahoogroups.com
> Date: Friday, July 17, 2009, 1:08 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hi Kanka
>
>
>
> Not being a poweruser of FireBird I have not modified anything in there and should be the default that is at the time of install.
>
>
>
> Checking this on my home machine there is no entry for this (execpt as a comment in the header) should be the same on the work computer. Of course I will confirm this tomorrow
>
>
>
> Thanks for your response.
>
>
>
> Bhavbhuti
>
>
>
> --- In firebird-support@ yahoogroups. com, Kanka sumatra <javakqj@ > wrote:
>
> >
>
> >
>
> > What is there the value of RemoteBindAddress in the firebird.conf ?
>
> >
>
> > --- On Fri, 7/17/09, Bhavbhuti Nathwani <venussoftop@ ...> wrote:
>
> >
>
> > From: Bhavbhuti Nathwani <venussoftop@ ...>
>
> > Subject: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.)
>
> > To: firebird-support@ yahoogroups. com
>
> > Date: Friday, July 17, 2009, 11:08 AM
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > 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]
>