Common problems in managing database connections

This topic describes some common problems in managing database connections.

My database requests fail with a “connection reset by peer” message

This error is normally a result of either the database server timing out the database connection, or of the network connection being timed out by a firewall. This problem can be resolved by setting the ConnectionTimeout element to ensure validation of connections that exceed the timeout.

My database connections are not being released when traffic drops

Setting the MaxPoolSize property on the data source will allow the number of database connections to drop back to predefined limits as connections are freed.

I share a database with other applications. I cannot allow theSterling Configurator Visual Modeler to use more than n connections

Setting the MaxConnections property on the data source will allow you to limit the maximum number of database connections used by the Sterling Configurator Visual Modeler.