MySQL Forums :: C#, Mono, .Net :: max_user_connections exceeded

Hello,

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.

Thanks,
SL