Can't open more than 128 connections

From: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Can't open more than 128 connections
Date: 2008-02-05 16:24:52
Message-ID: C3D5057033EDF145B90A99CD9025BFEA07EBB0@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"

. 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.

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Nguyen, Lam Thuy 2008-02-05 16:44:06 How to open more than 300 connections to postgres database.
Previous Message Nguyen, Lam Thuy 2008-02-05 14:42:41 Re: can't open more than 128 connections