.NET Framework Data Provider for SQL Server

[Doug]

We are using the .net framework data provider for SQL, but
have hit a problem that we have not been able to solve
regardless of the timeouts or conncetion pooling settings
on the server.

We more times than not get this error:
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.

Has anyone hit this problem and/or have any
recommendations to fix or a connection string that may
help?

Thanks,
Doug

[Michael Evanchik]

are you .close ing your connections in your code? especially if
your doing dynamic coding you need to do this.

Mike

"Doug" <ro**********@y ahoo.com> wrote in message news:<03******* *************** ******@phx.gbl> ...

We are using the .net framework data provider for SQL, but
have hit a problem that we have not been able to solve
regardless of the timeouts or conncetion pooling settings
on the server.

We more times than not get this error:
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.

Has anyone hit this problem and/or have any
recommendations to fix or a connection string that may
help?

Thanks,
Doug

[Doug]

Yes,

This is our code...
finally
{
// clean up connection and adapter
if (null != sqlConnection)
{
if (sqlConnection. State ==
System.Data.Con nectionState.Op en)
sqlConnection.C lose();
sqlConnection.D ispose();
}
if (null != dataAdapter) dataAdapter.Dis pose
();
dataAdapter = null;
sqlConnection = null;

}

-----Original Message-----
are you .close ing your connections in your code? especially ifyour doing dynamic coding you need to do this.

Mike

"Doug" <ro**********@y ahoo.com> wrote in message

news:<03******* *************** ******@phx.gbl> ...

We are using the .net framework data provider for SQL, but have hit a problem that we have not been able to solve
regardless of the timeouts or conncetion pooling settings on the server.

We more times than not get this error:
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.

Has anyone hit this problem and/or have any
recommendations to fix or a connection string that may
help?

Thanks,
Doug

.