Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

Connection not closed?

https://forums.devart.com/viewtopic.php?f=3&t=2270

Page 1 of 1

Connection not closed?

Posted: Fri 25 Nov 2005 09:04
by ConiKost
Hello!
I want, that after a successfull select the connection is going to be closed.
So i used

Code: Select all

pgReader.Close()
pgConnection.Close()
But my PostgreSQL Server reports that a connection is still in use ... only when i quit the hole programm my servers doen`t show this connection any more.

Wheres the Problem ?

Posted: Fri 25 Nov 2005 09:41
by SecureGen
It is because of connection pooling functionality which is ON by default. Such behavior is standard for ADO.NET data providers. If you do not need connection pooling you can add ";pooling=false" option to connection string.

Posted: Fri 25 Nov 2005 10:51
by ConiKost
Perfect!
Thanks for Help!

Everything is working now :)
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/