--- 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 driver used in all cases was 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 ====================================================== 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'; ============================================== Em qui, 12 de jul de 2018 às 10:07, Adrian Klaver <adrian.kla...@aklaver.com> escreveu: > On 07/12/2018 05:19 AM, Igor Korot wrote: > > ,Hi, > > > > On Wed, Jul 11, 2018 at 10:33 PM, Edgard Battisti Guimarães > > <edgard...@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.kla...@aklaver.com > -- Edgard Battisti Guimarães