timeout expired error

I am using visual web developer and the odbc driver to connect to a
mysql database. It seems like every four or five connections to the
database cause an error. For instance, in the logs I get the following
information:
[5/2/2006 4:34:08 PM] SELECT * FROM tAuthUsers WHERE Username =
'featurecreep' AND Password = '$$$$'
[5/2/2006 4:34:08 PM] Setting Company Id Var: $$$$
[5/2/2006 4:34:08 PM] INSERT INTO Keys (Company, Security, Created)
VALUES('$$$', '$$$', NOW())
[5/2/2006 4:34:08 PM] SELECT * FROM Keys WHERE Security = '$$$' AND
Company = '$$$' AND Created < '2006-05-03T04:34:08' AND Created >
'2006-05-02T04:34:08'
[5/2/2006 4:34:23 PM] 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.
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at
MySql.Data.MySqlClient.MySqlPoolManager.GetConnect ion(MySqlConnectionString
settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at cms._InsertMessageIntoSystem(String MobileNo, String MessageText,
Int32 CompanyId, Int32 CampaignId)

Can anybody point me to any information regarding the cause of this
error or perhaps suggest a solution to it? I am not sure what is
causing it, nor am I at all sure how to solve the error.

Can you please make sure you are closing the connection properly?

This may help you to solve this issue.

Regards,
Vinu.P.K

lambelly@gmail.com wrote:
> I am using visual web developer and the odbc driver to connect to a
> mysql database. It seems like every four or five connections to the
> database cause an error. For instance, in the logs I get the following
> information:
> [5/2/2006 4:34:08 PM] SELECT * FROM tAuthUsers WHERE Username =
> 'featurecreep' AND Password = '$$$$'
> [5/2/2006 4:34:08 PM] Setting Company Id Var: $$$$
> [5/2/2006 4:34:08 PM] INSERT INTO Keys (Company, Security, Created)
> VALUES('$$$', '$$$', NOW())
> [5/2/2006 4:34:08 PM] SELECT * FROM Keys WHERE Security = '$$$' AND
> Company = '$$$' AND Created < '2006-05-03T04:34:08' AND Created >
> '2006-05-02T04:34:08'
> [5/2/2006 4:34:23 PM] 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.
> at MySql.Data.MySqlClient.MySqlPool.GetConnection()
> at
> MySql.Data.MySqlClient.MySqlPoolManager.GetConnect ion(MySqlConnectionString
> settings)
> at MySql.Data.MySqlClient.MySqlConnection.Open()
> at cms._InsertMessageIntoSystem(String MobileNo, String MessageText,
> Int32 CompanyId, Int32 CampaignId)
>
> Can anybody point me to any information regarding the cause of this
> error or perhaps suggest a solution to it? I am not sure what is
> causing it, nor am I at all sure how to solve the error.

Vinu.P.K wrote:
> Can you please make sure you are closing the connection properly?
>
> This may help you to solve this issue.
>
> Regards,
> Vinu.P.K
>

I believe it is. The code for each query follows this format:
con = new MySql.Data.MySqlClient.MySqlConnection();
myConnectionString = "server=????;uid=????;" +
"pwd=????;database=Interface;";
con.ConnectionString = myConnectionString;
con.Open();

string Sql = null;
Sql = "INSERT INTO Keys (Company, Key, Created) VALUES('" +
Company + "', '" + m_SecKey + "', NOW())";
_Debug(Sql);
cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = con;
cmd.CommandText = Sql;
cmd.ExecuteNonQuery();
//MySQLCommand cmd = new MySQLCommand(Sql, conn);
//_DestroyDatabase();
con.Close();

Each query I mentioned opens a connection to the database and closes it.