Thread: [ psqlodbc-Bugs-1005624 ] The limitation for number of connection with ODBC driver

Bugs item #1005624, was opened at 2007-05-29 13:21
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1005624&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Dmitry Dmitriev (dmitry_12)
Assigned to: Nobody (None)
Summary: The limitation for number of connection with ODBC driver

Initial Comment:
We have the big trouble, when our application try to open number of
connection more than 128 with psqlODBC-08_02_0200 driver.

The following file fragment psqlodbc.h  from official PostgreSQL web site:
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fodbc%2Fversions%2Fsrc%2Fpsqlodbc-08.02.0400.tar.gz

...
 #define MAX_MESSAGE_LEN    65536  /* This puts a limit on
             * query size but I don't */
 /* see an easy way round this - DJP 24-1-2001 */
#define MAX_CONNECT_STRING   4096
#define ERROR_MSG_LENGTH   4096
#define FETCH_MAX     100 /* default number of rows to cache
           * for declare/fetch */
#define TUPLE_MALLOC_INC   100
#define SOCK_BUFFER_SIZE   4096  /* default socket buffer
             * size */
#define MAX_CONNECTIONS    128 /* conns per environment
           * (arbitrary) */
#define MAX_FIELDS     512
#define BYTELEN      8
#define VARHDRSZ     sizeof(Int4)
...

We need at least 2048 connections for our application.
Can you help us to solve the problem?

Thank you,
Dmitry Dmitriev
Technical Director
Magistral LLC.

email: dydmitriev@yahoo.com


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1005624&group_id=1000125