Re: ADO OLEDB connection to MSSQL: pooling not working

From: N.D. van Bochove (dvbochove_at_hotmail.com)
Date: 02/19/05 

Date: 18 Feb 2005 15:32:36 -0800

Thomas Holme wrote:

>
> When I close the Table (but not the connection) the port used for the
> connection enters a state called "TIME_WAIT". Here (in the resource
> pool) it remains for 4 minutes, then it is flushed and goes away.
>

Appearently, for some reason, the connection is closes when you close
the table. TIME_WAIT is a TCP thing, and is the state every TCP (not
only MSSQL) connection gets when it's closed. I believe (and someone
corrects me when I'm wrong) it is done because after a TCP connection
is closed, packets could still arive, and should be discarded. That's
why the TCP connection enters the TIME_WAIT status, to prevent a new
connection to use the same port number (client port number that is, not
the server port number 1433) too soon.

Anyway, when you see a connection in TIME_WAIT, that connection is
closed, and cannot be used again. If the connection would be in a pool
for reuse, it would still be open on th TCP level.

Regards, Diederik

Relevant Pages

  • RE: Configure Hardware Firewall for SBS 2003
    ... the corresponding ports to the SBS box. ... When a router is deployed at the SBS end, you must forward the port numbers ... TCP 110 This port is used for POP3 mail clients. ... TCP 1723 PPTP VPN connection ...
    (microsoft.public.windows.server.sbs)
  • Re: HTTP DDoS attack on our servers
    ... A quick googling for TCP port 45836 turns up the following page at ... The worm creates a remote access server by listening on TCP ... > Basically,> 8.000 IP numbers are sending HTTP requests to our server on ... > connection after the first sent line, ...
    (Incidents)
  • Re: .NET SqlConnection: connect error SQL Server 2005 DEV on same
    ... If I wanted to specify the port in the conenct string, ... enable TCP in the surface area configuration? ... Rick Byham, SQL Server Books Online ... An error has occurred while establishing a connection to the ...
    (microsoft.public.sqlserver.connect)
  • Re: Correction
    ... Normally to physically disconnect is just a matter of reaching for the ... >> I have an ADSL connection which polls my computer from time to time, ... > disallow each and every port with Windows Firewall? ...
    (microsoft.public.windowsxp.messenger)
  • Re: Using Remote Desktop From an SBS Domain
    ... when you tried to RDP while attached directly to a port on your router? ... Internet to initiate an IP conversation with your computer. ... This situation is different than if you ran your own NAT connection sharing ...
    (microsoft.public.windows.server.sbs)