Hi,

Can anybody explain the problems I have been having getting Firebird
to work with Indy?

I wrote a client/server application using Indy components that
updates a Firebird (Super Server) database. The database updates are
performed in the "OnExecute" method of the Indy TIdTCPServer
component. Each database connection is obtained from a database
connection pool (within a Critical Section as the "OnExecute" method
is called in the context of the connection thread).

Everything works fine with just one client (i.e. one connection to
the database). When two clients connect though, the server 'locks'
up.

At first I believed that this was either a problem with my code or a
bug in Indy. However, when I replaced Firebird SS with FBEmbedded
everything works perfectly. Anybody got any thoughts on why?

If you would like a full description of everything I've tried, take
a look at http://www.experts-
exchange.com/Programming/Programming_Languages/Delphi/Q_20973320.html
#10983872

If you would like a copy of the Delphi code that demonstrates the
problem, you can download it here: http:\\www.helion-
studios.com\download\ThreadTest.zip (see the link above for details
on compiling).

I'm using Delphi 7 Arch, DBExpress and Firebird 1.5.

Any help would be much appreciated.

Cheers,
Paul