Skip navigation links

MySQL Forums :: Connector/NET and C#, Mono, .Net :: User already has more than 'max_user_connections' active connections


Advanced Search

User already has more than 'max_user_connections' active connections
Posted by: Martin Wählby ()
Date: February 08, 2008 04:00AM

I'm using MySql with asp.net 2.0 and my mysql-user at my webhost are allowed max 15 connections. Right now I'm the only one using the site and after using the site for a while I get the following error:

"User *** already has more than 'max_user_connections' active connections"

My webhost says I probably just don't close my connections but I'm using the following way of binding my data (and I suppose asp.net close the connections for me):

<asp:SqlDataSource
ID="DS"
ConnectionString="<%$ ConnectionStrings:conn %>"
DataSourceMode="DataReader"
runat="server"
ProviderName="MySql.Data.MySqlClient" SelectCommand="SELECT id FROM table" CancelSelectOnNullParameter="false">
</asp:SqlDataSource>
<asp:Repeater DataSourceID="DS" ID="Repeater" runat="server"></asp:Repeater>



My ConnectionString in my web.config looks like this:

<add name="conn" connectionString="Data Source=mysql.domain.com;Database=db;User ID=***;Password=***;Pooling=false;"/>

I tried to add the "Pooling=false" to get rid of the problem but it didn't seem to help.


Anyone got the same problem? How can I solve it?



Thanks for your help!

Options: ReplyQuote


Subject Written By Posted
User already has more than 'max_user_connections' active connections Martin Wählby 02/08/2008 04:00AM
Re: User already has more than 'max_user_connections' active connections Martin Wählby 02/10/2008 06:25AM
Re: User already has more than 'max_user_connections' active connections Pepijn Bicker 02/11/2008 11:37AM
Re: User already has more than 'max_user_connections' active connections Reggie Burnett 02/29/2008 06:11PM


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.