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

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