Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database connections

Status
Not open for further replies.

664950

Programmer
Aug 27, 2001
28
BA
Why does my ADO connection remains after I do connection.close? It seems that database connection is closed but is still visible on connections list on UNIX server. This is a real problem considering problem of connection licencing. So I have up to 10 connections from the same client although I allways do connection.close on the termination of application. When I work in Visual studio 6, all my connections are raised even when I close the project. They are raised until I close Visual Basic?!
 
Try setting the connection to Nothing after closing it.
 
could be using connection pooling but then it should reuse the connection in that case. Is your app a standalone EXE?
 
OK I did it and it works. But I'm quite shure that I have tried something like that in the past, but I had error message.

Thanks,

Bojan

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top