SCM

[#1005624] The limitation for number of connection with ODBC driver

View Trackers | Bugs | Download .csv | Monitor

Date:
2007-05-29 09:21
Priority:
3
State:
Open
Submitted by:
Dmitry Dmitriev (dmitry_12)
Assigned to:
Hiroshi Saito (h-saito)
Category:
Group:
Resolution:
None
Category:
Group:
Resolution:
None
Summary:
The limitation for number of connection with ODBC driver

Detailed description
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

Followup

Message
Date: 2007-05-30 06:21
Sender: Hiroshi Inoue

Could you try the the drivers on testing for 8.2.0402
at http://www.geocities.jp/inocchichichi/psqlodbc/
?

regards,
Hiroshi Inoue

Attached Files:

Changes:

Field Old Value Date By
assigned_tonone2007-05-30 04:48dmitry_12
Powered By FusionForge