ADO/SQL Server connection releasing

[666539]

I've noticed that in the SQL Server performance monitor, when my application starts, as I open up forms that establish connections the performance monitor shows that the number of connections is increasing. When I close the forms it doesn't look like the number of connections goes down. The connections don't go down until the program is closed.

Is there something I need to put in my code to close those connections? What ramifications are there to the connections not being closed down?

[Clunietp]

in what scope do you have your connection object? (global/module/procedure)

Does your application reside within IIS or MTS?

[666539]

The application isn't using IIS or MTS.

I've tried the connection object as a local variable in the form load event and as a global variable. It seems to work the same way in both events.

[Clunietp]

I don't know, this code works fine for me. I have verified it using the performance monitor

Private Sub Form_Load()
    
    Dim cn As Connection
    Set cn = New Connection
    
    cn.Open "Provider=SQLOLEDB;Data Source=W2kSRV;Integrated Security=SSPI;"
    
End Sub

I didn't explicitly close or release the connection object to see if this was the problem, but the implicit object destruction worked fine....

Note that I am using ADO 2.5, the native OLEDB provider for SQL server (not ODBC), and SQL Server 7 SP2