ODBC timeout

Hi,

Is there an option in the ODBC driver that keeps the connection active?
I am using WinSQL (http://synametrics.com) as the client tool and it
disconnects after a while from the server. I would like to know if there
is any setting in the driver that continuously sends some messages to
the server so that it won't kill the connection.

Thanx,
Imran.




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: ODBC timeout

Assuming your using windows: go into the Data Sources (ODBC) manager, go to
the Connection Pooling tab, find the MyODBC driver, double-click on it.
Select "Pool connections to this driver" and then adjust your time for
unused connections as necessary. Be reasonable, however, as long connection
times may cause larger amounts of memory consumption, so increment it until
you find a suitable solution. Additionally, in the Connection Pooling tab,
you'll see a "Retry Wait Time" which is the number of seconds before your
system tries to reconnect to the database server (default is 120secs). Try
setting this to 60 and see if this helps.


>From: Imran Abizar
>To: myodbc@lists.mysql.com
>Subject: ODBC timeout
>Date: Tue, 30 May 2006 16:18:23 -0400
>MIME-Version: 1.0
>Received: from lists.mysql.com ([213.136.52.31]) by
>bay0-mc3-f14.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Tue,
>30 May 2006 13:18:38 -0700
>Received: (qmail 9742 invoked by uid 510); 30 May 2006 20:17:00 -0000
>Received: (qmail 9720 invoked by uid 509); 30 May 2006 20:16:59 -0000
>Received: pass (lists.mysql.com: local policy)
>X-Message-Info: txF49lGdW4245i0Zogv6DwilBGFf7jHKIeMWeWQEGrk=
>Mailing-List: contact myodbc-help@lists.mysql.com; run by ezmlm
>List-ID:
>Precedence: bulk
>List-Help:
>List-Unsubscribe:
>
>List-Post:
>List-Archive: http://lists.mysql.com/myodbc/10794
>Delivered-To: mailing list myodbc@lists.mysql.com
>X-SMarshall: 287419
>X-SMScore: -2500
>User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
>Return-Path: myodbc-return-10794-billywill31=hotmail.com@lists.mysql.com
>X-OriginalArrivalTime: 30 May 2006 20:18:39.0306 (UTC)
>FILETIME=[3CF6AAA0:01C68426]
>
>Hi,
>
>Is there an option in the ODBC driver that keeps the connection active? I
>am using WinSQL (http://synametrics.com) as the client tool and it
>disconnects after a while from the server. I would like to know if there is
>any setting in the driver that continuously sends some messages to the
>server so that it won't kill the connection.
>
>Thanx,
>Imran.
>
>
>
>
>--
>MySQL ODBC Mailing List
>For list archives: http://lists.mysql.com/myodbc
>To unsubscribe:
>http://lists.mysql.com/myodbc?unsub=billywill31@hotmail.com
>



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org