MySQL Forums
Forum List  »  Connector/ODBC

Solution
Posted by: Erik Hoekstra
Date: March 10, 2005 10:59AM

I found a solution to this problem, at least it was in our case.
Windows 2003 Server Web Edition connecting to Linux Redhat /MySQL

The cause of the problem may be found in the ODBC Connection pooling on the Windosw machine. By default the time-out on ODBC-connections in ODBC 3.5 is set to 120 secs. So if an application (IIS) is not using the ODBC-driver for 2 minutes, the connection is released. For the next request a new connection has to be made. This is a time-consuming process, which also depends on your TCP/IP-settings.

For information on "connection pooling" and how to tune it visit:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169470
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp

or just google around.

Options: ReplyQuote


Subject
Written By
Posted
October 01, 2004 01:41AM
October 09, 2004 07:47AM
February 07, 2005 01:28PM
October 11, 2004 10:43AM
H B
October 20, 2004 11:22AM
November 03, 2004 05:45PM
November 07, 2004 05:39AM
November 29, 2004 01:57PM
November 30, 2004 05:30AM
December 02, 2004 01:17AM
Solution
March 10, 2005 10:59AM
March 11, 2005 02:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.