C# MySQL "connection has been disabled" error

[MervinKoops]

Hello,
i'm building a server application in C#.net which connects to a MySQL server via ODBC/Connector 5.1 .Net

If a execute a query it works but when i try to exectute a query after waiting a while (ex. 5 minutes) i get an error which says:
"The connection has been disabled.".

I'd like to have a persistant connection to the database but I still haven't found out how to do that, so i thought it might be wise to ask here now.

Mervin.

[Ramy Mahrous]

Do you use Vista?
if you do; you can read this http://fci-h.blogspot.com/2007/02/mysql-net-connector-error-2869-on.html

[MervinKoops]

Thanks for the idea,
I tried it but it didn't not work. (running vista ultimate 32 bit , service pack 2 as admin)

i get this error: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.30]MySQL server has gone away the exception.message = "Connection has been disabled"

how could i make the connection persistent?

[Ramy Mahrous]

I don't have specific solution but try to ask in MySQL forum http://www.daniweb.com/forums/forum126.html or just something got to my mind is to open visual studio as administrator.

[Ramesh S]

Try the solution given in this link:

http://www.cryer.co.uk/brian/mswinswdev/ms_vbnet_the_connection_has_been_disabled.htm

Also use .NET Connector for MySQL instead of ODBC connector.

[MervinKoops]

Try the solution given in this link:

http://www.cryer.co.uk/brian/mswinswdev/ms_vbnet_the_connection_has_been_disabled.htm

Also Use .NET Connector for MySQL instead of ODBC connector.

that link is not for the InnerException i get [08S01]
it's about max packet size , i'm inserting a four letter string in 1 row so that's not the problem.