Disabling Connection Pool
Posted by: Tej Sidhu
Date: September 09, 2006 01:07PM

Hi

I am using the .NET connector to connect from ASP.NET to MySQL database. I sometimes receive the error message below. I was thinking this was todo with connection pooling so in the connection string I added the following pooling=false;

This however doesn't seem to release the connections as I can still see them building up in MySQL Administrator Server Connections.

I'd appreciated if anyone can help me resolve this problem.

Thanks

Source Method: Service_GetInfo
---------
Error: #08004Too many connections
Source: MySql.Data
Stack Trace: at MySql.Data.MySqlClient.PacketReader.CheckForError()
at MySql.Data.MySqlClient.PacketReader.ReadHeader()
at MySql.Data.MySqlClient.PacketReader.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.Authenticate411()
at MySql.Data.MySqlClient.NativeDriver.Authenticate()
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at DataServices.Open()
at DataServices.CreateCommand(String procName, MySqlParameter[] prams)
at DataServices.RunProc(String procName, MySqlDataReader& dataReader, MySqlParameter[] prams, String sourceMethod)
at ServiceFunctions.Service_GetInfo(Char chrServiceType)
---------
Execution Error: #08004Too many connections

Options: ReplyQuote


Subject
Written By
Posted
Disabling Connection Pool
September 09, 2006 01:07PM


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.