Database Connections not getting closed
Posted on 2003-02-21
I am using DataGrid controls based on a Data Environment command object which provides a record set.
When i open the form everything loads fine and a database connection is made.
I close the form, but i am still in the application, but the connection to the database is not getting closed.
In this way if i have 20 users and 30 forms (most of the forms i am using the data grid control based on Data Environment) and i am using atleast 1000 connections which are not getting closed unless the user exits from the application.
Most of the time i get Database conections maxed out.
How can we close the connections of the Datagrids underlying recordset which was based on a command in a Dataenvironment?
Is there any way to close the connection?