Re: ADO and TCPIP Connections

Jason Fischer wrote:

No, I have not disabled connection pooling.
That was one of the things I had a look at as well.

Could the Server Side cursor on the query be doing something to the
connection pooling maybe??? Just a thought.


not that I am aware of. It is very strange that having connection
pooling enabled you get so many connections as 1000, unless the
ADOQueries/ADOConnections are, for whatever reason, never really closed.

Either case you could try to adjust some TCP/IP settings to minimize
the problem. See following URL

http://support.microsoft.com/default.aspx?scid=kb;en-us;328476

It is for SQL Server but I guess some suggestions could help you.

I would also check the connection string. You can find most of them in

http://www.connectionstrings.com

For further detail we would need to know which RDBMS do you use

Good luck
--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages