From: | "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com> |
---|---|
To: | "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Can't open more than 128 connections |
Date: | 2008-02-05 18:29:46 |
Message-ID: | C3D5057033EDF145B90A99CD9025BFEA07EBB6@hont05.fcg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
I did not use psqlodbc driver, i used OdbcConnection of Net 2.0.
and if i user psqlodbc driver, At the 20th connection attempt, i got an error : Timeout while getting a connection from pool.
i use postgres verion 8.2.4.1
Thanks for your help.
________________________________
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
Sent: Tue 2/5/2008 12:42 PM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Can't open more than 128 connections
Nguyen, Lam Thuy wrote:
> hello,
>
> I'm trying to open 300 connections to a database using Microsoft odbc
> .NET and psqlodbc. At the 129th connection attempt i get an
> exception:
>
> {"ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's
> SQLAllocHandle on SQL_HANDLE_DBC failed" }
> State: "IM005"
Which version of psqlodbc driver are you using ?
regards,
Hiroshi Inoue
This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient. Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
From | Date | Subject | |
---|---|---|---|
Next Message | Nguyen, Lam Thuy | 2008-02-05 18:34:34 | Re: Can't open more than 128 connections |
Previous Message | Hiroshi Inoue | 2008-02-05 17:42:19 | Re: Can't open more than 128 connections |