Hi,

At September 18, 2003, 08:37, lalopus wrote:

> I still would like to know why this only happens when using
> ClientDataSet...

It might due to the fact that when using Midas/DataSnap or almost any
other middle-tier layer, that the middle-tier server connects and
disconnects from Firebird/Interbase server only when a request is sent
from the client, since the client is not responsible to open and close
the database connection. And, that in most cases it's a separate
instance of the datasets for each connection. I know KbmMW fixed that
problem by using TIB_Connection.DisconnectToPool, which permits to
reuse a connection handle instead of detroying it and creating a new
one everytime. And, the same can probably be applied to DataSnap. It's
already a solution for web modules.

When developing a two-tier C/S application, the client application
controls the connection and disconnection to the database, which is
most of the time: connect when starting application and disconnect when
closing application.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)