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

From: Edgard Battisti Guimarães <edgardbg1(at)gmail(dot)com>
To: h-inoue(at)dream(dot)email(dot)ne(dot)jp
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'"
Date: 2018-07-17 01:19:28
Message-ID: CAK+hLKSeQ9KVDaCQ6M=ZTJfjq1N--kHyCKsUHzZ1qZQ+q58Lww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Hiroshi,

When I was working to get more tracing, I found the problem.

It was not anything bad related to pgsqlodbc driver, but only a dirty
installation, where some WINDOWS ODBC dlls of a wrong version was in the
way of my app path before the correct ones in de windows system. They was
simply removed and the pgsqlodbc connection worked like a Stradivarius
violin. :)

Thanks very much for your time!!!!

best regards,

Em dom, 15 de jul de 2018 às 09:17, Inoue, Hiroshi <
h-inoue(at)dream(dot)email(dot)ne(dot)jp> escreveu:

> Hi Edgard,
>
> On 2018/07/15 7:31, Edgard Battisti Guimarães wrote:
>
> Hi Hiroshi,
>
> Thans for your help,
>
> I´ve already turned on that global ODBC trace available in the Microsoft
> ODBC config window, but it did´nt registered any entry from this connect
> attempt. Then I tested the same pgsqlodbc DSN via a generic ODBC viewer and
> that trace worked ok.
>
> Is there any way that I can do to have more detailed trace? Maybe a debug
> version of pgsqlodbc?
>
>
> The driver's log has little meaning because Driver manager returns IM001
> without calling driver's function.
> Please use the trace tool of powerbuilder.
>
> regards,
> Hiroshi Inoue
>
>
> thanks again.
>
> regards.
>
> Em sáb, 14 de jul de 2018 às 02:05, Inoue, Hiroshi <
> h-inoue(at)dream(dot)email(dot)ne(dot)jp> escreveu:
>
>> Hi Edgard,
>>
>> On 2018/07/14 0:32, Edgard Battisti Guimarães 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.
>> Can anyone help me?
>>
>> - The application send the connect command and receive error "IM001"as a
>> response.
>> - The ODBC DSN interface test shows "connection successful".
>> - The log tell us that the connection to the database was effectively
>> completed by the driver. The connect script command received an error IM001.
>> - All versions of the odbc driver and database are reported in the logs.
>> - The connection string and the used parameters etc are fully documented
>> in the logs.
>> - I've tried many basic stuff like upgrade/downgrade versions of the
>> driver and database without success.
>> - The powerbuilder version is an old 32 bit 6.5
>> - The psqlodbc driver used was the 32 bit one.
>> - The ODBC Global tracing was turned on too but any one entry was made
>> from the powerbuilder app.
>>
>>
>> Possibly powerbuilder tries to calls an SQL function which is not
>> implemented
>> by psqlodbc.
>> Could you send me the ODBC trace directly?
>>
>> regards,
>> Hiroshi Inoue
>>
>> - The entire PB app is really big, so follows the script initial part
>> with the connect and the ini file content with the parameters. I can make a
>> minimalist PB script to help with the problem isolation.
>> - 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
>>
>>
>> L O G S:
>> ============
>> psqlodbc.log error message in evidence ============
>> ============
>> [0.022]conn=005EF438, PGAPI_DriverConnect( in)='DRIVER={PostgreSQL
>> Unicode};Server=localhost;Port=5432;Database=onbpdc;Username=dba;Password=sql;',
>> fDriverCompletion=1
>> [0.047]Driver Version='09.05.0300,Jun 17 2016' linking 1800 dynamic
>> Multithread library
>> [0.049]Global Options: fetch=100, unknown_sizes=0, max_varchar_size=255,
>> max_longvarchar_size=8190
>> [0.051] unique_index=1, use_declarefetch=0
>> [0.052] text_as_longvarchar=1, unknowns_as_longvarchar=0,
>> bools_as_char=1 NAMEDATALEN=64
>> [0.053] extra_systable_prefixes='dd_',
>> conn_settings='(null)' conn_encoding=''
>> [0.157]conn=005EF438, query='SET DateStyle = 'ISO''
>> [0.172]conn=005EF438, query='SET extra_float_digits = 2'
>> [0.183]conn=005EF438, query='select oid, typbasetype from pg_type where
>> typname = 'lo''
>> [0.193] [ Large Object oid = -999 ]
>> [0.194] [ Client encoding = 'UTF8' (code = 6) ]
>> [0.200]conn=005EF438, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL
>> Unicode};DATABASE=onbpdc;SERVER=localhost;PORT=5432;UID=dba;PWD=sql;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=1;CommLog=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=1;LowerCaseIdentifier=0;GssAuthUseGSS=0;XaOpt=1'
>> ================================
>> ================================
>> ================================
>> ================================
>> [0.214]CONN ERROR: func=PGAPI_GetInfo, desc='', errnum=-2, errmsg='The
>> buffer was too small for the InfoValue.'
>> ================================
>> ================================
>> ================================
>> ================================
>> [0.217]
>> ------------------------------------------------------------
>> [0.217] henv=005E5770, conn=005EF438, status=1, num_stmts=16
>> [0.218] pqconn=005ECA80, stmts=005E6C70, lobj_type=-999
>> [0.231]conn=005EF438, query='show max_identifier_length'
>> [0.268]conn=005EF438, PGAPI_Disconnect
>>
>>
>>
>> Mylog error message evidenced ======
>> =====
>> [21184-0.000]ci=00000000 globals.extra_systable_prefixes = 'dd_'
>> [21184-0.002]exe name=onibus plaformId=2
>> [21184-0.004][[SQLAllocHandle]][21184-0.005]**** in PGAPI_AllocEnv **
>> [21184-0.006]** exit PGAPI_AllocEnv: phenv = 005E5770 **
>> [21184-0.007][[SQLSetEnvAttr]] att=200,2
>> [21184-0.008][[SQLAllocHandle]][21184-0.009]PGAPI_AllocConnect:
>> entering...
>> [21184-0.010]**** PGAPI_AllocConnect: henv = 005E5770, conn = 005EF438
>> [21184-0.012]EN_add_connection: self = 005E5770, conn = 005EF438
>> [21184-0.014] added at 0, conn->henv = 005E5770, conns[0]->henv =
>> 005E5770
>> [21184-0.015][SQLGetInfoW][21184-0.016]PGAPI_GetInfo:
>> entering...fInfoType=77
>> [21184-0.018]PGAPI_GetInfo: p='03.51', len=0, value=0, cbMax=12
>> [21184-0.019][SQLDriverConnectW][21184-0.019]PGAPI_DriverConnect:
>> entering...
>> [21184-0.019]**** PGAPI_DriverConnect: fDriverCompletion=1,
>> connStrIn='DRIVER={PostgreSQL
>> Unicode};Server=localhost;Port=5432;Database=onbpdc;Username=dba;Password=sql;'
>> [21184-0.025]CC_conninfo_init opt=2
>> [21184-0.025]copy_globals driver=PostgreSQL Unicode
>> [21184-0.026]our_connect_string = 'DRIVER={PostgreSQL
>> Unicode};Server=localhost;Port=5432;Database=onbpdc;Username=dba;Password=sql;'
>> [21184-0.027]attribute = 'DRIVER', value = '{PostgreSQL Unicode}'
>> [21184-0.028]copyAttributes:
>> DSN='',server='',dbase='',user='',passwd='',port='',onlyread='',conn_settings='(null)')
>> [21184-0.029]attribute = 'Server', value = 'localhost'
>> [21184-0.029]copyAttributes:
>> DSN='',server='localhost',dbase='',user='',passwd='',port='',onlyread='',conn_settings='(null)')
>> [21184-0.030]attribute = 'Port', value = '5432'
>> [21184-0.030]copyAttributes:
>> DSN='',server='localhost',dbase='',user='',passwd='',port='5432',onlyread='',conn_settings='(null)')
>> [21184-0.031]attribute = 'Database', value = 'onbpdc'
>> [21184-0.032]copyAttributes:
>> DSN='',server='localhost',dbase='onbpdc',user='',passwd='',port='5432',onlyread='',conn_settings='(null)')
>> [21184-0.033]attribute = 'Username', value = 'dba'
>> [21184-0.033]copyAttributes:
>> DSN='',server='localhost',dbase='onbpdc',user='dba',passwd='',port='5432',onlyread='',conn_settings='(null)')
>> [21184-0.035]attribute = 'Password', value = 'sql'
>> [21184-0.035]copyAttributes:
>> DSN='',server='localhost',dbase='onbpdc',user='dba',passwd='xxxxx',port='5432',onlyread='',conn_settings='(null)')
>> [21184-0.036]getDSNinfo: DSN= overwrite=0
>> [21184-0.036]our_connect_string = 'DRIVER={PostgreSQL
>> Unicode};Server=localhost;Port=5432;Database=onbpdc;Username=dba;Password=sql;'
>> [21184-0.038]attribute = 'DRIVER', value = '{PostgreSQL Unicode}'
>> [21184-0.038]copyCommonAttributes:
>> A7=100;A9=0;B0=255;B1=8190;B2=1;B3=1;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[21184-0.039]attribute
>> = 'Server', value = 'localhost'
>> [21184-0.040]copyCommonAttributes:
>> A7=100;A9=0;B0=255;B1=8190;B2=1;B3=1;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[21184-0.041]attribute
>> = 'Port', value = '5432'
>> [21184-0.041]copyCommonAttributes:
>> A7=100;A9=0;B0=255;B1=8190;B2=1;B3=1;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[21184-0.042]attribute
>> = 'Database', value = 'onbpdc'
>> [21184-0.043]copyCommonAttributes:
>> A7=100;A9=0;B0=255;B1=8190;B2=1;B3=1;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[21184-0.043]attribute
>> = 'Username', value = 'dba'
>> [21184-0.044]copyCommonAttributes:
>> A7=100;A9=0;B0=255;B1=8190;B2=1;B3=1;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[21184-0.045]attribute
>> = 'Password', value = 'sql'
>> [21184-0.045]copyCommonAttributes:
>> A7=100;A9=0;B0=255;B1=8190;B2=1;B3=1;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[21184-0.046]calling
>> getDSNdefaults
>> [21184-0.046]CC_connect: entering...
>> [21184-0.046]sslmode=disable
>> [21184-0.047]LIBPQ_CC_connect: entering...
>> [21184-0.048]Driver Version='09.05.0300,Jun 17 2016' linking 1800 dynamic
>> Multithread library
>> [21184-0.055]LIBPQ_CC_connect: DSN = '', server = 'localhost', port =
>> '5432', database = 'onbpdc', username = 'dba', password='xxxxx'
>> [21184-0.056]connecting to the database using localhost as the server
>> [21184-0.147]libpq connection to the database established.
>> [21184-0.147]protocol=3
>> [21184-0.147]Server version=9.5.13
>> [21184-0.148]LIBPQ_connect: retuning 1
>> [21184-0.148]CC_send_settings: entering...
>> [21184-0.148]PGAPI_AllocStmt: entering...
>> [21184-0.149]**** PGAPI_AllocStmt: hdbc = 005EF438, stmt = 005FDC30
>> [21184-0.149]CC_add_statement: self=005EF438, stmt=005FDC30
>> [21184-0.150]PGAPI_ExecDirect: entering...0
>> [21184-0.150]SC_recycle_statement: self= 005FDC30
>> [21184-0.150]**** PGAPI_ExecDirect: hstmt=005FDC30, statement='SET
>> DateStyle = 'ISO''
>> [21184-0.151]PGAPI_ExecDirect: calling PGAPI_Execute...
>> [21184-0.152]PGAPI_Execute: entering...0
>> [21184-0.152]PGAPI_Execute: clear errors...
>> [21184-0.152]PGAPI_NumParams: entering...
>> [21184-0.153]SC_scanQueryAndCountParams: entering...
>> [21184-0.153]prepareParameters was not called, prepare state:8
>> [21184-0.154]SC_recycle_statement: self= 005FDC30
>> [21184-0.154]Exec_with_parameters_resolved: copying statement params:
>> trans_status=1, len=21, stmt='SET DateStyle = 'ISO''
>> [21184-0.155] stmt_with_params = 'SET DateStyle = 'ISO''
>> [21184-0.155]about to begin SC_execute
>> [21184-0.156] it's NOT a select statement: stmt=005FDC30
>> [21184-0.156]CC_send_query: conn=005EF438, query='SET DateStyle = 'ISO''
>> [21184-0.157]in QR_Constructor
>> [21184-0.158]exit QR_Constructor
>> [21184-0.158]send_query: ok - 'C' - SET
>> [21184-0.158]send_query: setting cmdbuffer = 'SET'
>> [21184-0.159]send_query: returning res = 005EC748
>> [21184-0.159]SC_set_Result(5fdc30, 5ec748)[21184-0.160]QResult: enter
>> DESTRUCTOR
>> [21184-0.160]retval=0
>> [21184-0.160]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
>> [21184-0.161]CC_send_settings: result 0, status 1 from 'SET DateStyle =
>> 'ISO''
>> [21184-0.161]PGAPI_ExecDirect: entering...0
>> [21184-0.162]SC_recycle_statement: self= 005FDC30
>> [21184-0.162]SC_set_Result(5fdc30, 0)[21184-0.162]QResult: enter
>> DESTRUCTOR
>> [21184-0.163]QResult: in QR_close_result
>> [21184-0.163]QResult: free memory in, fcount=0
>> [21184-0.163]QResult: free memory out
>> [21184-0.164]QResult: exit close_result
>> [21184-0.164]QResult: exit DESTRUCTOR
>> [21184-0.164]PDATA_free_params: ENTER, self=005FDDFC
>> [21184-0.165]**** PGAPI_ExecDirect: hstmt=005FDC30, statement='SET
>> extra_float_digits = 2'
>> [21184-0.166]PGAPI_ExecDirect: calling PGAPI_Execute...
>> [21184-0.166]PGAPI_Execute: entering...0
>> [21184-0.167]PGAPI_Execute: clear errors...
>> [21184-0.167]PGAPI_NumParams: entering...
>> [21184-0.168]SC_scanQueryAndCountParams: entering...
>> [21184-0.168]prepareParameters was not called, prepare state:8
>> [21184-0.169]SC_recycle_statement: self= 005FDC30
>> [21184-0.169]PDATA_free_params: ENTER, self=005FDDFC
>> [21184-0.169]Exec_with_parameters_resolved: copying statement params:
>> trans_status=1, len=26, stmt='SET extra_float_digits = 2'
>> [21184-0.170] stmt_with_params = 'SET extra_float_digits = 2'
>> [21184-0.171]about to begin SC_execute
>> [21184-0.171] it's NOT a select statement: stmt=005FDC30
>> [21184-0.172]CC_send_query: conn=005EF438, query='SET extra_float_digits
>> = 2'
>> [21184-0.172]in QR_Constructor
>> [21184-0.173]exit QR_Constructor
>> [21184-0.173]send_query: ok - 'C' - SET
>> [21184-0.174]send_query: setting cmdbuffer = 'SET'
>> [21184-0.174]send_query: returning res = 005EC748
>> [21184-0.174]SC_set_Result(5fdc30, 5ec748)[21184-0.175]QResult: enter
>> DESTRUCTOR
>> [21184-0.175]retval=0
>> [21184-0.175]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
>> [21184-0.176]CC_send_settings: result 0, status 1 from 'SET
>> extra_float_digits = 2'
>> [21184-0.177]PGAPI_FreeStmt: entering...hstmt=005FDC30, fOption=1
>> [21184-0.177]QResult: enter DESTRUCTOR
>> [21184-0.177]QResult: in QR_close_result
>> [21184-0.178]QResult: free memory in, fcount=0
>> [21184-0.178]QResult: free memory out
>> [21184-0.178]QResult: exit close_result
>> [21184-0.179]QResult: exit DESTRUCTOR
>> [21184-0.179]SC_init_Result(5fdc30)[21184-0.179]SC_Destructor:
>> self=005FDC30, self->result=00000000, self->hdbc=005EF438
>> [21184-0.180]APD_free_params: ENTER, self=005FDD40
>> [21184-0.180]IPD_free_params: ENTER, self=005FDD80
>> [21184-0.181]PDATA_free_params: ENTER, self=005FDDFC
>> [21184-0.181]SC_Destructor: EXIT
>> [21184-0.182]CC_send_settings: entering...
>> [21184-0.182]CC_send_settings: entering...
>> [21184-0.182]CC_lookup_lo: entering...
>> [21184-0.183]CC_send_query: conn=005EF438, query='select oid, typbasetype
>> from pg_type where typname = 'lo''
>> [21184-0.184]in QR_Constructor
>> [21184-0.185]exit QR_Constructor
>> [21184-0.186]num_fields = 2
>> [21184-0.187]in QR_set_num_fields
>> [21184-0.187]exit QR_set_num_fields
>> [21184-0.187]QR_from_PGResult: fieldname='oid', adtid=26, adtsize=4,
>> atttypmod=-1 (rel,att)=(1247,-2)
>> [21184-0.188]QR_from_PGResult: fieldname='typbasetype', adtid=26,
>> adtsize=4, atttypmod=-1 (rel,att)=(1247,24)
>> [21184-0.189]QResult: enter DESTRUCTOR
>> [21184-0.190]QResult: in QR_close_result
>> [21184-0.190]QResult: free memory in, fcount=0
>> [21184-0.191]QResult: free memory out
>> [21184-0.191]QResult: exit close_result
>> [21184-0.192]QResult: exit DESTRUCTOR
>> [21184-0.192]Got the large object oid: -999
>> [21184-0.193]CC_lookup_characterset: entering...
>> [21184-0.194]conn->unicode=1
>> [21184-0.195]CC_connect: returning...1
>> [21184-0.195]szConnStrOut = 'DRIVER={PostgreSQL
>> Unicode};DATABASE=onbpdc;SERVER=localhost;PORT=5432;UID=dba;PWD=sql;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=1;CommLog=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=1;LowerCaseIdentifier=0;GssAuthUseGSS=0;XaOpt=1'
>> len=548,1536
>> [21184-0.205]PGAPI_DriverConnect: returning 0
>> [21184-0.205][SQLGetDiagRecW][21184-0.205]PGAPI_GetDiagRec entering
>> type=2 rec=1
>> [21184-0.206]**** PGAPI_ConnectError: hdbc=005EF438 <0>
>> [21184-0.206]enter CC_get_error
>> [21184-0.207]exit CC_get_error
>> [21184-0.207]CC_Get_error returned nothing.
>> [21184-0.208]PGAPI_GetDiagRec exiting 100
>> [21184-0.208][SQLGetFunctions][21184-0.208]PGAPI_GetFunctions:
>> entering...0
>> [21184-0.209][SQLGetInfoW][21184-0.209]PGAPI_GetInfo:
>> entering...fInfoType=23
>> [21184-0.210]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
>> [21184-0.210][SQLGetInfoW][21184-0.211]PGAPI_GetInfo:
>> entering...fInfoType=24
>> [21184-0.211]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
>> [21184-0.212][SQLGetInfoW][21184-0.212]PGAPI_GetInfo:
>> entering...fInfoType=6
>> [21184-0.213]PGAPI_GetInfo: p='PSQLODBC35W.DLL', len=0, value=0, cbMax=6
>> [21184-0.214]CC_error_statements: self=005EF438
>> ================================
>> ================================
>> ================================
>> ================================
>> [21184-0.215]CONN ERROR: func=PGAPI_GetInfo, desc='', errnum=-2,
>> errmsg='The buffer was too small for the InfoValue.'
>> ================================
>> ================================
>> ================================
>> ================================
>> [21184-0.218][SQLGetInfoW][21184-0.219]PGAPI_GetInfo:
>> entering...fInfoType=2
>> [21184-0.219]PGAPI_GetInfo: p='', len=0, value=0, cbMax=512
>> [21184-0.220][SQLGetInfoW][21184-0.220]PGAPI_GetInfo:
>> entering...fInfoType=17
>> [21184-0.220]PGAPI_GetInfo: p='PostgreSQL', len=0, value=0, cbMax=512
>> [21184-0.221][SQLGetInfoW][21184-0.221]PGAPI_GetInfo:
>> entering...fInfoType=6
>> [21184-0.221]PGAPI_GetInfo: p='PSQLODBC35W.DLL', len=0, value=0, cbMax=490
>> [21184-0.222][SQLGetInfoW][21184-0.222]PGAPI_GetInfo:
>> entering...fInfoType=16
>> [21184-0.225]PGAPI_GetInfo: p='onbpdc', len=0, value=0, cbMax=512
>> [21184-0.226][SQLGetInfoW][21184-0.226]PGAPI_GetInfo:
>> entering...fInfoType=25
>> [21184-0.227]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=512
>> [21184-0.227][SQLGetInfoW][21184-0.227]PGAPI_GetInfo:
>> entering...fInfoType=13
>> [21184-0.228]PGAPI_GetInfo: p='localhost', len=0, value=0, cbMax=512
>> [21184-0.230][SQLGetInfoW][21184-0.230]PGAPI_GetInfo:
>> entering...fInfoType=32
>> [21184-0.231]CC_send_query: conn=005EF438, query='show
>> max_identifier_length'
>> [21184-0.232]in QR_Constructor
>> [21184-0.232]exit QR_Constructor
>> [21184-0.233]num_fields = 1
>> [21184-0.233]in QR_set_num_fields
>> [21184-0.233]exit QR_set_num_fields
>> [21184-0.234]QR_from_PGResult: fieldname='max_identifier_length',
>> adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0)
>> [21184-0.234]REALLOC: old_count = 0, size = 0
>> [21184-0.234]qresult: len=2, buffer='63'
>> [21184-0.235]QResult: enter DESTRUCTOR
>> [21184-0.235]QResult: in QR_close_result
>> [21184-0.235]QResult: free memory in, fcount=1
>> [21184-0.236]QResult: free memory out
>> [21184-0.236]QResult: exit close_result
>> [21184-0.236]QResult: exit DESTRUCTOR
>> [21184-0.237]max_identifier_length=63
>> [21184-0.237]PGAPI_GetInfo: p='<NULL>', len=2, value=63, cbMax=2
>> [21184-0.237][SQLGetInfoW][21184-0.238]PGAPI_GetInfo:
>> entering...fInfoType=35
>> [21184-0.238]max_identifier_length=63
>> [21184-0.238]PGAPI_GetInfo: p='<NULL>', len=2, value=63, cbMax=2
>> [21184-0.241][SQLGetInfoW][21184-0.241]PGAPI_GetInfo:
>> entering...fInfoType=93
>> [21184-0.242]PGAPI_GetInfo: p='<NULL>', len=2, value=3, cbMax=2
>> [21184-0.242][SQLGetInfoW][21184-0.242]PGAPI_GetInfo:
>> entering...fInfoType=9
>> [21184-0.243]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=2
>> [21184-0.243][SQLGetInfoW][21184-0.244]PGAPI_GetInfo:
>> entering...fInfoType=15
>> [21184-0.244]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=2
>> [21184-0.245][SQLGetInfoW][21184-0.245]PGAPI_GetInfo:
>> entering...fInfoType=46
>> [21184-0.245]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
>> [21184-0.246][SQLGetInfoW][21184-0.246]PGAPI_GetInfo:
>> entering...fInfoType=8
>> [21184-0.246]PGAPI_GetInfo: p='<NULL>', len=4, value=191, cbMax=4
>> [21184-0.247][SQLGetInfoW][21184-0.247]PGAPI_GetInfo:
>> entering...fInfoType=43
>> [21184-0.247]PGAPI_GetInfo: p='<NULL>', len=4, value=5, cbMax=4
>> [21184-0.248][SQLGetInfoW][21184-0.248]PGAPI_GetInfo:
>> entering...fInfoType=44
>> [21184-0.249]PGAPI_GetInfo: p='<NULL>', len=4, value=19, cbMax=4
>> [21184-0.250][SQLGetInfoW][21184-0.250]PGAPI_GetInfo:
>> entering...fInfoType=14
>> [21184-0.250]PGAPI_GetInfo: p='\', len=0, value=0, cbMax=512
>> [21184-0.262][SQLGetInfoW][21184-0.262]PGAPI_GetInfo:
>> entering...fInfoType=94
>> [21184-0.263]PGAPI_GetInfo: p='_', len=0, value=0, cbMax=512
>> [21184-0.267][SQLDisconnect for 005EF438][21184-0.268]PGAPI_Disconnect:
>> entering...
>> [21184-0.268]PGAPI_Disconnect: about to CC_cleanup
>> [21184-0.269]in CC_Cleanup, self=005EF438
>> [21184-0.269]after PQfinish
>> [21184-0.270]CC_conninfo_init opt=1
>> [21184-0.270]exit CC_Cleanup
>> [21184-0.270]PGAPI_Disconnect: done CC_cleanup
>> [21184-0.271]PGAPI_Disconnect: returning...
>> [21184-0.271][[SQLFreeHandle]][21184-0.271]PGAPI_FreeConnect: entering...
>> [21184-0.272]**** in PGAPI_FreeConnect: hdbc=005EF438
>> [21184-0.272]enter CC_Destructor, self=005EF438
>> [21184-0.272]in CC_Cleanup, self=005EF438
>> [21184-0.273]after PQfinish
>> [21184-0.273]CC_conninfo_init opt=1
>> [21184-0.273]exit CC_Cleanup
>> [21184-0.274]after CC_Cleanup
>> [21184-0.274]after free statement holders
>> [21184-0.274]exit CC_Destructor
>> [21184-0.275]PGAPI_FreeConnect: returning...
>> [21184-0.275][[SQLFreeHandle]][21184-0.275]**** in PGAPI_FreeEnv: env =
>> 005E5770 **
>> [21184-0.276]in EN_Destructor, self=005E5770
>> [21184-0.276]clearing conns count=128
>> [21184-0.276]exit EN_Destructor: rv = 1
>> [21184-0.277] ok
>> [21184-0.277]DETACHING PROCESS
>>
>>
>> --
>> Edgard Battisti Guimarães
>>
>>
>
> --
> Edgard Battisti Guimarães
>
>

--
Edgard Battisti Guimarães

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2018-07-17 02:44:57 Re: Getting an error for unixODBC library "odbcinst" not found while executing ./configure --with-unixodbc=/usr --with-libpq=/apps/PostgreSQL/10 in SuSE Linux 12.0 SP1
Previous Message Clemens Ladisch 2018-07-16 18:57:50 Re: Getting an error for unixODBC library "odbcinst" not found while executing ./configure --with-unixodbc=/usr --with-libpq=/apps/PostgreSQL/10 in SuSE Linux 12.0 SP1