ODBC error "The buffer was too small for the InfoValue." - Mailing list pgsql-odbc

From Edson Richter
Subject ODBC error "The buffer was too small for the InfoValue."
Date
Msg-id BLU0-SMTP34B784D3CCD841A0ED5836CFAB0@phx.gbl
Whole thread Raw
Responses Re: ODBC error "The buffer was too small for the InfoValue."
List pgsql-odbc
I'm configuring a SQL Server 2K to replicate to PostgreSQL 9.2.4.

- SQL Server 2K (sp4) 32bit is running Win 2K (sp4) 32bit on a
VirtualBOX. ODBC PostgreSQL driver installed is latest compatible with
Win2K (9.01.02.00 ANSI). ODBC version is 3.525.1117.0;
- PostgreSQL 9.2.4 is running Win7 64bit on native;

PostgreSQL 9.2.4 is configured as Linked Server in Sql2K. There is no
firewall active in either servers. Both servers are connected in same
subnet (192.168.25.x).
Connections from Sql2K to PostgreSQL 9.2.4 are really slow - I don't
know why.
I've enabled logging so I can look into details and try to discover the
slowdown reason, and found that every connection throws the following error:

[524.782]CONN ERROR: func=PGAPI_GetInfo, desc='', errnum=-2, errmsg='The
buffer was too small for the InfoValue.'
[524.828] ------------------------------------------------------------
[524.844]            henv=01653B80, conn=01653BB0, status=1, num_stmts=16
[524.860]            sock=01656718, stmts=016587F8, lobj_type=-999
[524.860]            ---------------- Socket Info
-------------------------------
[524.907]            socket=660, reverse=0, errornumber=0, errormsg='(NULL)'
[524.922]            buffer_in=23422952, buffer_out=23427056
[524.938]            buffer_filled_in=2126, buffer_filled_out=0,
buffer_read_in=2126


Why is this happening?

Thanks,

Edson Richter



pgsql-odbc by date:

Previous
From: Andrei Gheorghe
Date:
Subject: Re: Retrieving output bind parameters not working
Next
From: Hiroshi Inoue
Date:
Subject: Re: ODBC error "The buffer was too small for the InfoValue."