Re: can't open more than 128 connections

Поиск
Список
Период
Сортировка
От Nguyen, Lam Thuy
Тема Re: can't open more than 128 connections
Дата
Msg-id C3D5057033EDF145B90A99CD9025BFEA07EBAF@hont05.fcg.com
обсуждение исходный текст
Ответ на can't open more than 128 connections  (Amir Zicherman <amir.zicherman@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Ben Kelada"
Дата:
Сообщение: packaging issue / upgrading with psql-odbc msi packages 8.03.01.00
Следующее
От: "Nguyen, Lam Thuy"
Дата:
Сообщение: Can't open more than 128 connections