Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Edgard Battisti Guimarães <edgardbg1(at)gmail(dot)com>
Cc: ikorot01(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'
Date: 2018-07-13 13:29:14
Message-ID: 2a121bc0-0732-6386-3175-5e16203d26f7@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/12/2018 04:56 PM, Edgard Battisti Guimarães wrote:
> --- The ODBC Global tracing was turned on too but any one entry was made
> from the powerbuilder app.
>
> --- No problem on sending the entire PB app, but it's really big, so
> follows the initial script with the connect and the ini file content
> with the parameters. I will make a minimalist PB script to help with the
> problem isolation.
>
> ---  The ODBC driverusedin all caseswas the 32 bit .
>
> --- The original computer where the program is working ok is a DELL
> laptop inspiron 7548 core i5  8GB
>
> --- The computer presenting the reported problem is a Lenovo Yoga laptop
> 720-121KB core i5 8GB
>
> --- The locale: The original and third computer are the same - The OS
> local is Portugues(Brasil), the language, date format, number format etc
> are the same: DD/MM/YYYY.  Numbers use comma as decimal point and dot as
> group separator.
>
> --- By running the script below, I receive a messagebox with the
> following content:
> ======================================================
> erro -1 na abertura do BD
>
> SQLSTATE = IM001
> [Microsoft]ODBC Driver Manager] Driver does not support this function
> ======================================================

My suggestion at this point would be to ask for advice on the -odbc list:

https://www.postgresql.org/list/pgsql-odbc/

>
>
>
> The PB script:
> ===========
> string s, s1, aux, aux1
> int qtc1, qtc2, retornoprofiles, atudbparms
> string chlic, chcalc, testa_nr_carros
> date dataref
> int i
>
>
> s = "ONIBUS.INI"
>
> sqlca.DBMS       = ProfileString (s, "sqlca", "dbms",       "")
> sqlca.dbparm     = ProfileString (s, "sqlca", "dbparm",     "")
>
>
> CONNECT using sqlca;
>
> if sqlca.sqlcode <> 0 then
> messagebox ("erro " + string(sqlca.sqlcode) + " na abertura do BD", &
> sqlca.sqlerrtext)
> if messagebox("ÔNIBUS","Se voce tem um Banco de Dados salvo~n"+&
> "pode usar a opção Arquivo/Retornar BD.~n~n"+&
> "Voce deseja prosseguir?",Question!, Yesno!) = 2 then
> return
> end if
> end if
>
>
>
>
> The ONIBUS.INI parameters file
> =========================
> [sqlca]
> dbms=ODBC
> DbParm=ConnectString='Driver={Postgresql
> Unicode};Server=localhost;Port=5432;Database=onbpdc;Uid=dba;Pwd=sql';
> ==============================================
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mathieu Fenniak 2018-07-13 13:34:39 Re: Optimizing execution of expensive subqueries
Previous Message Fabrízio de Royes Mello 2018-07-13 13:19:51 Re: Disable TRUST authentication by using ClientAuthentication_hook