Dear List:

Im considering the migration of a system from paradox to interbase. The system environment can be a mixture of NT,98 and 95 using TCI/IP connections to the Interbase server running on an NT workstation. The programs are written in Delphi using IBX components connecting via TCP/IP.

The programs connect once and use this connection for the remainder of their life. The program may run happily on one machine whilst another machine would either freeze or report one of the following TCP/IP error codes:
100054, 100053, 100061.

A test program starting a transaction opening and closing a query and then committing the transaction with a timer interval of 10 seconds had the same problems.

The problem seems worse on 95/98 clients.
The Select returned blob fields.
The problem eased when power saving was disabled.
I have placed Host files on all machines.

Could the problem be anything to do with multiple database connections in a program?
Could the number of connected users be causing the problem?
Should I disconnect the database connections on idle event, and reconnect when required?
Each datamodule uses its own TIBDatabase component, should I change all the datamodules to use the same connection?

Regards

Jason Berry


[Non-text portions of this message have been removed]