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 SkipVought 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
0
0
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