Error: Sorry, too many clients already

[osmarjunior]

Hi,

I'm using ODBC to connect to the dbms (Postgresql v8.1, in Windows
server).

After a few program open/close I get the message "Sorry, too many
clients already". I believe my database class properly closes the
connection when it is removed. Maybe not.

How do I see how many connections there are?
How would I terminate orphaned connections? Is this possible?

Regards.

Junior.

[Oberdan Borges Nunes]

Hi Junior,
make sure that your application is closing the connections every time.
Try to use using statement every it's possible.
If the problem persists, try to call GC.Collect() and
GC.WaitForPendingFinalizers() after closing the connections.

[]'s
Oberdan
"osmarjunior" <os*********@gmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...

Hi,

I'm using ODBC to connect to the dbms (Postgresql v8.1, in Windows
server).

After a few program open/close I get the message "Sorry, too many
clients already". I believe my database class properly closes the
connection when it is removed. Maybe not.

How do I see how many connections there are?
How would I terminate orphaned connections? Is this possible?

Regards.

Junior.

[Michael Nemtsev]

User Performance counters to check the number of connections

http://support.microsoft.com/kb/245543/EN-US/ and
http://support.microsoft.com/kb/169470/EN-US/

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche


"osmarjunior" wrote:

Hi,

I'm using ODBC to connect to the dbms (Postgresql v8.1, in Windows
server).

After a few program open/close I get the message "Sorry, too many
clients already". I believe my database class properly closes the
connection when it is removed. Maybe not.

How do I see how many connections there are?
How would I terminate orphaned connections? Is this possible?

Regards.

Junior.