Subject Creating a view into Firebird DB: "unable to complete network request to host...
Author drjimwalsh1
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
2.00.00.148, 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."

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.

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.

Thanks in advance for your help.

Jim