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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: can"t open more than 128 connections

=20

=20
hello,
=20
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:
=20
{"ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's
SQLAllocHandle on SQL_HANDLE_DBC failed" }
State: "IM005"
=20
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 at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Can"t open more than 128 connections

hello,
=20
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:
=20
{"ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's
SQLAllocHandle on SQL_HANDLE_DBC failed" }
State: "IM005"
=20
.. 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 at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Can"t open more than 128 connections

=20
Hello,
=20
I did not use psqlodbc driver, i used OdbcConnection of Net 2.0.
=20
and if i user psqlodbc driver, At the 20th connection attempt, i got an er=
ror : Timeout while getting a connection from pool.
i use postgres verion 8.2.4.1
=20
Thanks for your help.

=20
________________________________

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,
>=20
> 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:
>=20
> {"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 at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Can"t open more than 128 connections

and here is more info :
=20
I set max_connecion =3D300, but it only allows upto 128 connections.
=20
I tried to change some para in postgresql.conf file (shared_buffer...), but=
it was not efficient.
=20
I read some document in postgres site said that i should change some para o=
f System V IPC, but how do i change them ?
=20
I am using WinXP, SP2, 4GB of GAM
=20
Could you help me as soon as you can.
=20
I am look forward hearing you.
=20
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,
>=20
> 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:
>=20
> {"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 at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: 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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Can"t open more than 128 connections

=20
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:
>=20
> Hello,
>=20
> 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 at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Can"t open more than 128 connections

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



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly