Thread: Getting Handle allocation error

Hi list.
I'm forcing an error when the application tries to allocate the handle for a
statement. I force creating lots of handles until the maximum numbers are
achieved. Looking in a piece of MyLog below we can see that the error
occurred, but nothing is returned by the ODBC to the application. Does
anybody knows if there's some configuration to be done in the ODBC to solve
that?

Thank's,
Renato.

[3360]CONN ERROR: func=PGAPI_AllocStmt, desc='', errnum=203, errmsg='Maximum
number of connections exceeded.'
[3360]SC_Destructor: self=7f31e770, self->result=0, self->hdbc=c93a38
[3360]APD_free_params:  ENTER, self=2133977196
[3360]IPD_free_params:  ENTER, self=7f31e8ac
[3360]PDATA_free_params:  ENTER, self=7f31e914
[3360]SC_Destructor: EXIT
[3360][SQLGetDiagRecW][3360]PGAPI_GetDiagRec entering type=2 rec=1
[3360]**** PGAPI_ConnectError: hdbc=c93a38 <511>
[3360]enter CC_get_error
[3360]enter CC_create_errormsg
[3360]msg = ''
[3360]exit CC_create_errormsg
[3360]exit CC_get_error
[3360]CC_Get_error returned nothing.
[3360]PGAPI_GetDiagRec exiting 100

Renato Gondim wrote:
> Hi list.
> I'm forcing an error when the application tries to allocate the handle for a
> statement. I force creating lots of handles until the maximum numbers are
> achieved. Looking in a piece of MyLog below we can see that the error
> occurred, but nothing is returned by the ODBC to the application. Does
> anybody knows if there's some configuration to be done in the ODBC to solve
> that?
>

Could you try the dll at
  http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?

regards,
Hiroshi Inoue