Too many database connections

[bmarinel]

Hi,

I just want to share something that I learned about multiple database connections using TSQLCOnnection.

My reporting application runs a number of queries when it starts up. I have a timer set to disconnect 10 seconds after the last query completes. When I checked on the Sybase server I noticed that I had five database connections prior to disconnecting. The TSQLConnection was creating a number of cloned connections. I was able to solve this by setting Query.Prepared := False; after I closed each query. Then I was able to set TSQLConnection.AutoCLose := False;, and my application still worked.

Reagrds,

Bill

[Anordlun]

Hi.
Try TSQLConnection.AutoClone := false;
That prevents the connection to clone itself...
Remember to Unprepare the question after use.