Hejsan!

Jag har byggt en webbsajt som på förstasidan gör ett databas anrop. Detta fungerar men någonstans går det galet. Jag får nämligen följande fel, se nedan. Vad gör jag för fel? Mig veteligen så stänger jag kopplingen efter mig. Jag uppskattar starkt hjälp med detta!!!

// Nicke


----------- stack trace ---------
error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
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: MySql.Data.MySqlClient.MySqlException: error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

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:

[MySqlException: error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.]
MySql.Data.MySqlClient.MySqlPool.GetConnection() +211
MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings) +213
MySql.Data.MySqlClient.MySqlConnection.Open() +142
DatabaseLayer.DatabaseManager.Execute(String query) in DatabaseManager.cs:35
DatabaseLayer.UtilDAO.LookUpUserLocation(Int64 ipaddress) in UtilDAO.cs:18
ProcessLayer.UtilHandler.GetUserLocation(String ipaddress) in UtilHandler.cs:22
footer.Page_Load(Object sender, EventArgs e) +82
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Jag antar att du använder dig av MySQL-connectorn? I så fall kan det vara att du använder en för gammal version. jag hade ett liknande problem och uppgraderade till den senaste versionen (5.1.2) och sedan dess funkade det alldeles utmärkt!

Annars kan ett tips vara att kolla upp inställningarna för databasen, kör du localhost eller kopplar du upp dig mot en databas på ett webbhotell?