Re: can't open more than 128 connections

From: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>
To: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: can't open more than 128 connections
Date: 2008-02-05 14:42:41
Message-ID: C3D5057033EDF145B90A99CD9025BFEA07EBAF@hont05.fcg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Nguyen, Lam Thuy 2008-02-05 16:24:52 Can't open more than 128 connections
Previous Message Ben Kelada 2008-02-04 22:34:41 packaging issue / upgrading with psql-odbc msi packages 8.03.01.00