Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group