Member Avatar for llohl

The administrator quit- the site went down- when you login it points you to "mysql" has too many connections. we have done all the obvious mysql fixes and the problem is in the asp/net - the previous developer used visual studio?
We need someone to take a look and tell us what it takes to get it functional again. It is a small business database site. clients download pdf surveys- admin uploads into the db.

www.goldinspection.com

Server Error in '/' Application.

Database exception: MySQL has too many connections. Check to make sure default server settings allow correct number of connections.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Database exception: MySQL has too many connections. Check to make sure default server settings allow correct number of connections.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[Exception: Database exception: MySQL has too many connections. Check to make sure default server settings allow correct number of connections.]
GoldInspection.Engine.BaseMain..ctor() in C:\Documents and Settings\tatemononai\My Documents\Visual Studio 2005\Projects\GoldInspection\GoldInspection.Engine\BaseMain.cs:78
Interface.user_login(String userid, String password) +41
Interface.button_login_Click(Object sender, EventArgs e) +38
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

  • 4 Contributors
  • 6 Replies
  • 138 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by Paladine
Member Avatar for llohl

Ive been told the problem is GAC and runtime licenses in .Net , which i know nothing about-

Member Avatar for jbennet

what are you running it on?

different windows oses have diferent numbers of max. connections

Member Avatar for Paladine

Appears to be up and running again

Member Avatar for sushanth

Hi,
Increase the value for MAX_CONNECTIONS in MYSQL to 500 or more..

Member Avatar for sushanth

Hi, Its nothing to do with the window connections.. its all related to mysql. The exception message shows Mysql error so obviously it deals with maximum connections of mysql.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.