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 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 close the connections for me):

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

My ConnectionString in my web.config looks like this:

<add name="conn" connectionString="Data;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

Written By
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.