Subject Re: Creating a view into Firebird DB: "unable to complete network request to host...
Author drjimwalsh1

Thanks for responding to my posting.
To respond to your questions:

1. I am creating the remote view into the Firebird database using Visual FoxPro 9. I am using the View designer tool, a graphical tool that allows me to select tables and fields from the Firebird database. With VFP9, the view is "stored" in the VFP database of my project. It will be available to me like any local table in the VFP database of my project. So, it must be named. Frankly, I don't know exactly what is being "stored" internally. My belief is that VFP must be storing the connection info, and the SQL select statement. I don't know why (or if) it is trying to write something into the Firebird database. That doesn't seem to be needed. I just want to be able to read data from the tables in the Firebird database.

2. From interbase.log - It is not clear. Since other people were accessing Firebird before and after I did, although not while I was using it. There are Client messages reporting that IBserver.exe terminated abnormally (-1), and then Guardian messages saying that it is starting ibserver.exe. I will need to repeat the tests to see if I can track specific messages to my access.

Any other thoughts?


--- In, Helen Borrie <helebor@...> wrote:
> At 10:56 AM 15/12/2010, drjimwalsh1 wrote:
> >We have a Firebird database hosted on a WinXP computer in our network.
> >The IBSERVER is version 1.0.3.
> >
> >On another machine in the network (the client), I have created an ODBC
> >Data Source to that database. The Firebird ODBC driver is version
> >, dated 11/18/2008. Test the connection through the ODBC data
> >source in ODBC administrator is successful.
> >
> >I am trying to create a view into the database in VFP 9. I have created
> >a VFP connection to the Firebird DB via the ODBC data source. This
> >connects successfully.
> >
> >When I create the view in VFP 9, I am able to select multiple tables
> >from the DB, and fields from each of the tables. All of this works.
> >
> >However, when I attempt to save the View in VFP, I get the following
> >error: "Connectivity error: [ODBC Firebird Driver][Firebird]Unable to
> >complete request to host 'XPSERVER'. Error writing data to the
> >connection. The pipe is being closed."
> What do you mean by "save the view"? CREATE VIEW creates a view definition in the database. Simply succeeding and committing "saves" it.
> >The System event log on XPSERVER shows an entry that says that the
> >Firebird Server service terminated unexpectedly. It has done this 7
> >times. Each event of this type is following by one saying that the
> >Guardian has restarted the Firebird Server.
> If so, you should see some network errors reported in interbase.log (which is in the root dir of your server installation), along with (possibly) something interesting happening at the client or server close by in time.
> >I have no problems creating a remote view to the database if I copy the
> >database to the client computer. Still using the Firebird ODBC driver,
> >but this time to the local copy of the database.
> Still not clear what "creating a remote view to the database" means in Firebird terms.
> ./heLen