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.