Обсуждение: buffer size error

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][3708]PGAPI_GetDiagRec entering rec=1[3708]****
PGAPI_ConnectError: hdbc=124861136 <46>
[3708]enter CC_get_error
[3708]exit CC_get_error
[3708]CC_get_error: 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.'
[3708]PGAPI_GetDiagRec 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

>> -----Original Message-----
>> From: pgsql-odbc-owner@???
>> [mailto:pgsql-odbc-owner@???] On Behalf Of Max Cohan
>> Sent: 02 August 2005 17:47
>> To: pgsql-odbc@???
>> Subject: Re: [ODBC] psqlODBC 08.00.0102 available for download
>>
>>
>> I'm using ODBC via VB.NET (1.1)...
>> When I switch to this version I get the following error:
>> ODBC ERROR: [01004] The buffer was too small for the ConnStrOut.
>>
>
>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.

> -----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][3708]PGAPI_GetDiagRec entering rec=1[3708]****
> PGAPI_ConnectError: hdbc=124861136 <46>
> [3708]enter CC_get_error
> [3708]exit CC_get_error
> [3708]CC_get_error: 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.'
> [3708]PGAPI_GetDiagRec 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