Обсуждение: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

,Hi,

On Wed, Jul 11, 2018 at 10:33 PM, Edgard Battisti Guimarães
<edgardbg1@gmail.com> wrote:
> I've ported a powerbuilder application  to postgresql. Tested ok on windows
> 10 64, was installed on two win10-64 other computers, all connecting the
> postgresql database in the localhost with access via odbc. The third of them
> presented the error detailed below in the logs (mylog and psqlodbc)
> integrally copy and paste.

Which database the application connecting to initially?
Can you show the PB script that connects to the DB?
Can you show the credentials you are trying to connect with?
Can you turn on ODBC logging and send the log with the failure?

Thank you.

>
> --
> Edgard Battisti Guimarães
>

On 07/12/2018 05:19 AM, Igor Korot wrote:
> ,Hi,
> 
> On Wed, Jul 11, 2018 at 10:33 PM, Edgard Battisti Guimarães
> <edgardbg1@gmail.com> wrote:
>> I've ported a powerbuilder application  to postgresql. Tested ok on windows
>> 10 64, was installed on two win10-64 other computers, all connecting the
>> postgresql database in the localhost with access via odbc. The third of them
>> presented the error detailed below in the logs (mylog and psqlodbc)
>> integrally copy and paste.
> 
> Which database the application connecting to initially?
> Can you show the PB script that connects to the DB?
> Can you show the credentials you are trying to connect with?
> Can you turn on ODBC logging and send the log with the failure?

The above information is in the original post, with exception of PB script.

Given that the PB app is 32 bit and the computers are 64 bit I am 
wondering if on the third computer the wrong ODBC driver is being used?

Also what are the hardware specifications for the third computer 
relative to the other two?

Lastly the error message shows up in the source code of info.c in the 
section for Unicode support:

#ifdef  UNICODE_SUPPORT
     if (CC_is_in_unicode_driver(conn))
     {
             len = utf8_to_ucs2(p, len, (SQLWCHAR *) rgbInfoValue, 
cbInfoValueMax / WCLEN);
             len *= WCLEN;
     }
     else
#endif /* UNICODE_SUPPORT */
         strncpy_null((char *) rgbInfoValue, p, (size_t) cbInfoValueMax);

         if (len >= cbInfoValueMax)
         {
                 result = SQL_SUCCESS_WITH_INFO;
                 CC_set_error(conn, CONN_TRUNCATED, "The buffer was too 
small for the InfoValue.", func);
         }
}


So what is the locale for the third computer?

> 
> Thank you.
> 
>>
>> --
>> Edgard Battisti Guimarães
>>
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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.klaver@aklaver.com