Re: Win2K3 Client / Win2K3 & 2K SQL Server DBNETLIB Problem!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


We had the same problem: Webserver on 2003, SQL Server on 2000.
It seems (because of the hundreds of open ports) that connection
pooling is not working despite the setting in the ODBC-manager. The
solution for us was disabling the pooling, increasing the number of
TCPIP userports and decreasing the TCPIP timeout. See
http://tinyurl.com/ccvdk

Hove this will solve your problems too.

Grtz,
Dethmer



--
dethmer
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1053191.html

.

Relevant Pages

  • Re: ODBC/OLE DB Connection Pool
    ... > Connection Pool (I have already completed the TCP/IP tasks without ... turning off pooling is the errors you are seeing. ... problems are occurring with SQL Server; for example, ... ASP developers should open one connection per set of unique user ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > Connection Pool (I have already completed the TCP/IP tasks without ... turning off pooling is the errors you are seeing. ... problems are occurring with SQL Server; for example, ... ASP developers should open one connection per set of unique user ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > Connection Pool (I have already completed the TCP/IP tasks without ... turning off pooling is the errors you are seeing. ... problems are occurring with SQL Server; for example, ... ASP developers should open one connection per set of unique user ...
    (microsoft.public.data.oledb)
  • Re: Question about IDispose
    ... > SqlConnection.Close() if the connection is not already closed. ... > handles pooling just fine does). ... >to write a Dispose method that works properly with the pooling system ... >> are cheap, however, the reverse is true in a web environment. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ODBC/OLE DB Connection Pool
    ... > And if there is no global ADODB.Connection, there will be no pooling. ... The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)