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.


Recommended Answers

All 5 Replies

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.