| From: | Amir Zicherman <amir(dot)zicherman(at)gmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | can't open more than 128 connections |
| Date: | 2005-06-20 05:39:44 |
| Message-ID: | 27a5b7d105061922394b00187c@mail.gmail.com |
| Views: | Whole Thread | Raw Message | 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, amir
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Shaw | 2005-06-20 12:30:38 | Re: {? = call myfunc(?,?)} syntax for set-returning functions |
| Previous Message | Noel | 2005-06-17 19:45:10 | Re: Can I specify a SCHEMA in the ODBC string? |