PostgeSQL ODBC - buffer size error

Author

buffer size error

Noshiro, Kenya

2005-11-04, 3:23 am

Hello,

I am using Visual Basic .NET(1.1) as frontend,
PostgreSQL ver8.0.3 as backend and PostgreSQL ODBC driver ver 8.00.01.01
and experiencing "The buffer was too small for the ConnStrOut".

The SQL connection works OK for a while but eventually crushes all the
time !!

PostgreSQL encoding is set to LATIN1 and client encoding is set to UTF8.

[3708][SQLGetDiagRecW]& #91;3708]PGAPI_GetDi
agRec entering rec=1[3708]****
PGAPI_ConnectError: hdbc=124861136 <46>
[3708]enter CC_get_error
[3708]exit CC_get_error
& #91;3708]CC_get_erro
r: status = 215, msg = #The buffer was too small for
the ConnStrOut.#
[3708] szSqlState = '(null)',len=44, szError='The buffer was too
small for the ConnStrOut.'
& #91;3708]PGAPI_GetDi
agRec exiting 0

I have searched mailing list archive and found following thread.
So I have downloaded the latest snapshot, psqlodbc-08.01.005(Unicode)
to give it a try but it crushes with same error.

Has it been fixed yet or am I doing something wrong?
I do not know how to change buffer size for ConnStrOut in Visual Basic
..NET.
If you can advise me how to solve this problem, it is very much
appreciated.

Thanks in advance.

Best regards,

Kenya

>
>Hi Max,
>
>Yeah, I've noticed that error in recent testing. I hope to resolve it
>for the next snapshot in the next day or so.
>
>Regards,Dave.

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

Dave Page

2005-11-04, 3:23 am

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Noshiro, Kenya
> Sent: 03 November 2005 08:41
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] buffer size error
> Importance: High
>
> Hello,
>
>
> I am using Visual Basic .NET(1.1) as frontend,
> PostgreSQL ver8.0.3 as backend and PostgreSQL ODBC driver ver
> 8.00.01.01
> and experiencing "The buffer was too small for the ConnStrOut".
>
> The SQL connection works OK for a while but eventually crushes all the
> time !!
>
> PostgreSQL encoding is set to LATIN1 and client encoding is
> set to UTF8.
>
> [3708][SQLGetDiagRecW]& #91;3708]PGAPI_GetDi
agRec entering rec=1[3708]****
> PGAPI_ConnectError: hdbc=124861136 <46>
> [3708]enter CC_get_error
> [3708]exit CC_get_error
> & #91;3708]CC_get_erro
r: status = 215, msg = #The buffer was too small for
> the ConnStrOut.#
> [3708] szSqlState = '(null)',len=44, szError='The
> buffer was too
> small for the ConnStrOut.'
> & #91;3708]PGAPI_GetDi
agRec exiting 0
>
>
> I have searched mailing list archive and found following thread.
> So I have downloaded the latest snapshot, psqlodbc-08.01.005(Unicode)
> to give it a try but it crushes with same error.
>
> Has it been fixed yet or am I doing something wrong?

This (should) be resolved in 08.01.0006. Please confirm either way :-)

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links