Hi,

I Using VB 6.0 with ADO.

I need some Opinions regarding database connections.
DB.ConnectionString = ConString
DB.Open

I always design my programs when I run my application I will open the database connection, I will only close the connection when I exit from my application. But for my recordset, when I open a recordset for Inserting/updating records and I will close the recordset immediately after finish Inserting/updating the records.

But I got of Information that if I always maintain the database connections open(multi-user Environment), I will slow down the server in a way if a lot of users are connected .

Is it advisable to maintain the database connection open until I exit from my application?

Please advice.

Thanks.