Subject Re: [firebird-support] Creating a view into Firebird DB: "unable to complete network request to host...
Author Helen Borrie
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.