BUG #2438: error connect with odbc

From: "MATTASOGLIO DENIS" <mattasoglio(at)idbconsulting(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2438: error connect with odbc
Date: 2006-05-13 17:39:39
Message-ID: 200605131739.k4DHdd0E026175@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2438
Logged by: MATTASOGLIO DENIS
Email address: mattasoglio(at)idbconsulting(dot)com
PostgreSQL version: 8.1
Operating system: WINDOWS XP
Description: error connect with odbc
Details:

Hello world

i work with powerbuilder odbc and postgres

i can't manage transaction properly
and i got error message with odbc driver
is somebody know the :
CONN ERROR: func=PGAPI_GetInfo, desc='', errnum=215, errmsg='The buffer was
too small for the InfoValue.'

Thank's

Global Options: Version='08.02.0002', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=0, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
[ PostgreSQL version string = '8.1.2' ]
[ PostgreSQL version number = '8.1' ]
conn=31a3df8, query='select oid, typbasetype from pg_type where typname =
'lo''
[ fetched 0 rows ]
[ Large Object oid = -999 ]
[ Client encoding = 'UTF8' (code = 6) ]
conn=31a3df8,
PGAPI_DriverConnect(out)='DSN=gc_pgsql;DATABASE=gc;SERVER=localhost;PORT=543
2;UID=postgres;PWD=xxxxxxxx;CA=d;A6=;A7=100;A8=4096;B0=254;B1=8190;BI=0;C2=d
d_;;CX=1b50dbb;A1=7.4-1'
CONN ERROR: func=PGAPI_GetInfo, desc='', errnum=215, errmsg='The buffer was
too small for the InfoValue.'
------------------------------------------------------------
henv=31a3dc0, conn=31a3df8, status=1, num_stmts=16
sock=31a6920, stmts=31a8998, lobj_type=-999
---------------- Socket Info -------------------------------
socket=532, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=52062600, buffer_out=52066704
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
conn=31a3df8, query='show max_identifier_length'
[ fetched 1 rows ]
conn=31a9338, PGAPI_DriverConnect(
in)='DSN=gc_pgsql;UID=postgres;PWD=xxxxxxxx;', fDriverCompletion=1
DSN info:
DSN='gc_pgsql',server='localhost',port='5432',dbase='gc',user='postgres',pas
swd='xxxxx'

onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
Global Options: Version='08.02.0002', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=0, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
[ PostgreSQL version string = '8.1.2' ]
[ PostgreSQL version number = '8.1' ]
conn=31a9338, query='select oid, typbasetype from pg_type where typname =
'lo''
[ fetched 0 rows ]
[ Large Object oid = -999 ]
[ Client encoding = 'UTF8' (code = 6) ]
conn=31a9338,
PGAPI_DriverConnect(out)='DSN=gc_pgsql;DATABASE=gc;SERVER=localhost;PORT=543
2;UID=postgres;PWD=xxxxxxxx;CA=d;A6=;A7=100;A8=4096;B0=254;B1=8190;BI=0;C2=d
d_;;CX=1b50dbb;A1=7.4-1'
CONN ERROR: func=PGAPI_GetInfo, desc='', errnum=215, errmsg='The buffer was
too small for the InfoValue.'
------------------------------------------------------------
henv=31a3dc0, conn=31a9338, status=1, num_stmts=16
sock=31a8ed8, stmts=31aef68, lobj_type=-999
---------------- Socket Info -------------------------------
socket=540, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=52084320, buffer_out=53411912
buffer_filled_in=77, buffer_filled_out=0, buffer_read_in=77
conn=31a9338, query='show max_identifier_length'
[ fetched 1 rows ]
conn=31a9338, query='INSERT INTO public.gc_pc ( exr_id, pc_id, pc_typ,
statut ) VALUES ( 8, 24312, 'AA', 'O' )'
conn=31a9338, query='COMMIT'

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-05-13 17:51:51 Re: group by
Previous Message YourSoft 2006-05-13 13:12:55 group by