Date: December 01, 2011 03:02PM
I'm getting an application crash indicating I'm exceeding ODBC's max_user_connections in the following scenario:
I have a .net application running on a hosted server on which I use MySQL with ODBC 3.51 driver. I don't believe I have control over the the selection of driver.
A listbox, filled by a query/read responds to a click on a selected item. More data is read on this event and displayed in text boxes.
For safety, I create a new connection with each query and close the connection after each read. I assume c# garbage-cleans constructed objects.
Anyway, after 5 iterations of clicking on list items, the crash occurs, forcing me to "recycle" an App Pool.
I don't know if there is a way to tweak the max_user_connections (or where to do that, if I could), nor why even when my code closes connections explicitly should I be getting this error.
By the way, this application exists as well in Windows Forms and runs standalone on a PC with MySQL 5.1 -- and, I have no such issues. It's only when I migrated it to a web .net platform that I encountered this.
Any advice would be appreciated.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.