Обсуждение: can't open more than 128 connections
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"
I know that my db can take over 300 connections without using the odbc
driver because i open 300 connections with psql with no problem. Is
there some config param i need to set on the connection string so that
i can take more connections? what am i doing wrong?
thank you, amir
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"
I know that my db can take over 300 connections without using the odbc
driver because i open 300 connections with psql with no problem. Is
there some config param i need to set on the connection string so that
i can take more connections? what am i doing wrong?
thank you
This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the
intendedrecipient. Any review, reliance, or distribution by others or forwarding without express permission is
strictlyprohibited. If you are not the intended recipient, please contact the sender and delete all copies.
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"
. Is there some config param i need to set on the connection string so that
i can take more connections? what am i doing wrong?
thank you
This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the
intendedrecipient. Any review, reliance, or distribution by others or forwarding without express permission is
strictlyprohibited. If you are not the intended recipient, please contact the sender and delete all copies.
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
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
frompool.
i use postgres verion 8.2.4.1
Thanks for your help.
________________________________
From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]
Sent: Tue 2/5/2008 12:42 PM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc@postgresql.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
intendedrecipient. Any review, reliance, or distribution by others or forwarding without express permission is
strictlyprohibited. If you are not the intended recipient, please contact the sender and delete all copies.
and here is more info :
I set max_connecion =300, but it only allows upto 128 connections.
I tried to change some para in postgresql.conf file (shared_buffer...), but it was not efficient.
I read some document in postgres site said that i should change some para of System V IPC, but how do i change them ?
I am using WinXP, SP2, 4GB of GAM
Could you help me as soon as you can.
I am look forward hearing you.
Lam
________________________________
From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]
Sent: Tue 2/5/2008 12:42 PM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc@postgresql.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
intendedrecipient. Any review, reliance, or distribution by others or forwarding without express permission is
strictlyprohibited. If you are not the intended recipient, please contact the sender and delete all copies.
Nguyen, Lam Thuy wrote: > > Hello, > > I did not use psqlodbc driver, i used OdbcConnection of Net 2.0. Aren't you specifying a DataSource or a Driver in your connection string when you use odbc.net ? Please upgrade the psqlodbc driver to 8.2.0500 or later. regards, Hiroshi Inoue
I am using psqlodbc 8.2.03, is it the cause ? if i upgrade , can i open more than 128 connections ? ________________________________ From: Hiroshi Inoue [mailto:inoue@tpf.co.jp] Sent: Tue 2/5/2008 6:56 PM To: Nguyen, Lam Thuy Cc: pgsql-odbc@postgresql.org Subject: Re: [ODBC] Can't open more than 128 connections Nguyen, Lam Thuy wrote: > > Hello, > > I did not use psqlodbc driver, i used OdbcConnection of Net 2.0. Aren't you specifying a DataSource or a Driver in your connection string when you use odbc.net ? Please upgrade the psqlodbc driver to 8.2.0500 or later. regards, Hiroshi Inoue This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intendedrecipient. Any review, reliance, or distribution by others or forwarding without express permission is strictlyprohibited. If you are not the intended recipient, please contact the sender and delete all copies.
Nguyen, Lam Thuy wrote: > > I am using psqlodbc 8.2.03, is it the cause ? > if i upgrade , can i open more than 128 connections ? Maybe yes. 8.3.0100 was released three days ago. regards, Hiroshi Inoue