SQLExecute failure

[Sakthiu]

When i try to execute SQLStatements, i got below error message. Could any folks please help me out ?. SQLExecute failed: SQLState:08S01 NativeError:2006 ErrorText:[MySQL][ODBC 3.51 Driver][mysqld-4.1.20]MySQL server has gone away and then the connection is broken. i have to reconnect to SQLServer for every SQLExecute failure. Thanks, Sakthi

Nice things do nice works

[sunilsb]

Have you tried changing the "wait_timeout" server variable?

[Sakthiu]

yes i tried. still i see that error. +sakthi

Nice things do nice works

[sunilsb]

This could either be the MySQL Server version issue. Check whether it is 4.1 or above

[Sakthiu]

Yes. it is mysqld-4.1.20.

Nice things do nice works