Disabling Connection Pooling - MySQL + ASP.NET

[tejssidhu]

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

 

[rac2]

Do you explicitly close connections when you are finished?