Re: ADO and TCPIP Connections

Hi,

I am using SQL Server 2000.
I will read the links and see if I find anything handy, thanks.

"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:xn0eiv81n5qeij000@xxxxxxxxxxxxxxxxxxxxxxxxx
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

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Resets
    ... When we turn on connection pooling, it loads up pretty fast to throw the ... I tend to believe it has something to do with the connection pooling. ... Have you had a look at the SQL Server ... Have you tested the development environment with MaxUserPort=64534, ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Resets
    ... Let's try another network configuration. ... This time we will try to increase the backlog of the Winsock library that SQL Server uses to listen for connections. ... That means that the maximum pending connection sockets you can hold is five. ... If you disable connection pooling and the app ran slower maybe you ...
    (microsoft.public.sqlserver.connect)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)