How to flush Database connection

[darkradar]

Hi

I am having problem in connecting to SQL Server .
My software is a POS software where client POS will
connect to Server POS through VPN and dump the data into server and connection will be disconnected. I have nearly
40 POSclients. At the end of the day they will connect
to POSServer and dump the data and will be disconnected.
I am using SQL Server7.0 with 5 user connection.
But sometimes at the client they are getting an error
"Cannot connect to SQL Server. More than 5 users are
connected". I checked in the Server. It is showing some
of the POS Clients are still connected eventhough they
disconnected long back. It seems its not flushing the memory.Any help will be highly appreciated
I am using VB6.0 and SQL Server7.0

Thanks in advance

 

[hmckillop]

Ensure you explicitly close your connection object and also set the variable to be nothing.
i.e.

MyDBConn.Close
Set MyDBConn = nothing