I'm trying to track down a tricky problem. I have an application that uses
ODBC to migrate millions of rows of data in a script from a proprietary
database to Firebird. The application takes about 10 hours to run entirely.
I have it committing its updates about every 1,000 rows or so to FB.

After about 7 hours of operations, I'm getting errors for every attempt to
connect to Firebird. Prior to this all was fine, but for some reason the
ODBC connection dropped. I'm not sure why as the boxes are on my LAN and
the connection to the server has been maintained. It would appear that for
some reason the connection was dropped.

When I run the same migration with a Firebird database installed on the same
machine, but running a local Server (hence a Network connection to
127.0.0.1), it works fine and completes the entire run. But when the
database is over the network, I get this drop out after 7 hours of
operations. The Firebird database is running on Fedora Core 5 Linux and is
a Firebird Super Server 1.5.3 database.

Other than changing my code to detect a disconnect and attempt to re-login
again and continue, are there any reasons why this might happen (ie. A
setting somewhere that I need to change)?

Myles




============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
www.techsol.org