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=...ie.nctu.edu.tw

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.




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=...ie.nctu.edu.tw