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.
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
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?
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.
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.
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.