From: Michael Widenius
Date: April 20 1999 11:59pm
Subject: timeout-problem
List-Archive: http://lists.mysql.com/mysql/2143
Message-Id: <14109.5243.529521.377624@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Paul" == Paul Schwarzl <support@stripped> writes:

Paul> Hi there!
Paul> I connect to mysql (on Linux) with odbc. when I do nothing for about 10
Paul> minutes and try then do some sql-executes (without reconnect) I get the
Paul> following odbc-error message:

Paul> Error with SQL-Execute!
Paul> ODBC-Errorinformation: [TCX][MyODBC]Lost connection to MySQL server during
Paul> query (S:S1000,M:2013).

Paul> I have set the mysql variables connect_timeout=60 and long_query_time=60
Paul> (the wait_timeout=28800).
Paul> But that does not help.

Paul> What is to do?

Paul> best regards
Paul> Paul

Hi!

What MySQL/MyODBC version are you using?  If you are using MyODBC
2.50.21 and MySQL 3.21 it should work if you upgrade MyODBC or MySQL.

Regards,
Monty