can't open more than 128 connections

Поиск
Список
Период
Сортировка
От Amir Zicherman
Тема can't open more than 128 connections
Дата
Msg-id 27a5b7d105061922394b00187c@mail.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, amir

В списке pgsql-odbc по дате отправления:

Предыдущее
От: vladimir
Дата:
Сообщение: Re: Can I specify a SCHEMA in the ODBC string?
Следующее
От: "James Shaw"
Дата:
Сообщение: Re: {? = call myfunc(?,?)} syntax for set-returning functions