Re: can't open more than 128 connections - Mailing list pgsql-odbc

From Nguyen, Lam Thuy
Subject Re: can't open more than 128 connections
Date
Msg-id C3D5057033EDF145B90A99CD9025BFEA07EBAF@hont05.fcg.com
Whole thread Raw
In response to can't open more than 128 connections  (Amir Zicherman <amir.zicherman@gmail.com>)
List pgsql-odbc


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. 

pgsql-odbc by date:

Previous
From: "Ben Kelada"
Date:
Subject: packaging issue / upgrading with psql-odbc msi packages 8.03.01.00
Next
From: "Nguyen, Lam Thuy"
Date:
Subject: Can't open more than 128 connections