ODBC error "The buffer was too small for the InfoValue."

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC error "The buffer was too small for the InfoValue."
Date: 2014-02-03 03:32:21
Message-ID: BLU0-SMTP34B784D3CCD841A0ED5836CFAB0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2014-02-04 11:56:11 Re: ODBC error "The buffer was too small for the InfoValue."
Previous Message Andrei Gheorghe 2014-01-30 09:22:25 Re: Retrieving output bind parameters not working