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=3DPGAPI_AllocStmt, desc=3D'', errnum=3D203, errmsg=
=3D'Maximum
number of connections exceeded.'
[3360]SC_Destructor: self=3D7f31e770, self->result=3D0, self->hdbc=3Dc93a38
[3360]APD_free_params: ENTER, self=3D2133977196
[3360]IPD_free_params: ENTER, self=3D7f31e8ac
[3360]PDATA_free_params: ENTER, self=3D7f31e914
[3360]SC_Destructor: EXIT
[3360][SQLGetDiagRecW][3360]PGAPI_GetDiagRec entering type=3D2 rec=3D1
[3360]**** PGAPI_ConnectError: hdbc=3Dc93a38 <511>
[3360]enter CC_get_error
[3360]enter CC_create_errormsg
[3360]msg =3D ''
[3360]exit CC_create_errormsg
[3360]exit CC_get_error
[3360]CC_Get_error returned nothing.
[3360]PGAPI_GetDiagRec exiting 100


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Getting Handle allocation error

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match