ADO Connection to Firebird stays connected.

views:

answers:

ADO Connection to Firebird stays connected.

I've noticed that ADO Connections to our FireBird 2.1 Server stays open. The connections are initiated from an Intraweb Application in the UserSession Unit.

I use ADOConnection.Connected := False; but that does not seem to close the connection. I've also tried ADOConnection.Close;.

Is there a way to ensure that an ADO Connection is closed?

Thanks, Pieter.Blockquote

You can try to free and recreate TADOConnection object.

Linas 2010-08-26 10:25:26

Are you sure that IW is using that exactly TADOConnection object? Or a new connection object is being created behind-the-scenes and you forgot to clean it?

Fabricio Araujo 2010-08-26 16:23:05

(to add to that) Can you see the connection count? If so, make sure that you get exactly one new connection when the program starts. And that the extra connection goes away when the program is shut down. We make a lot of ADO connections from our app and have not had this problem.

moz 2010-08-27 03:50:47

ansaurus

tags:

views:

answers:

ADO Connection to Firebird stays connected.

related questions