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
February 08, 2008 04:00AM


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.