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