Re: Delphi7, ADO, ODBC and PostgreSQL connection problems - Mailing list pgsql-odbc

From Mikhail Umorin
Subject Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Date
Msg-id B0015232795@vljcms10.ucmretail.internal.callsciences.com
Whole thread Raw
In response to Delphi7, ADO, ODBC and PostgreSQL connection problems  ("Mikhail Umorin" <mikeumo@onebox.com>)
List pgsql-odbc
That was a log from the legacy driver (2.5) I tried just in case. I also tried Unicode (beta) with same "success". But
hereis the part of the log from the ODBC3.0 psqlodbc.dll driver (it has slightly different diagnostics): 

...
[-787737]READING ATTTYPMOD
[-787737]CI_read_fields: fieldname='pg_client_encoding', adtid=19, adtsize=64, atttypmod=-1
[-787737]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[-787737]MALLOC: tuple_size = 100, size = 800
[-787737]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[-787737]qresult: len=9, buffer='SQL_ASCII'
[-787737]end of tuple list -- setting inUse to false: this = 33951312
[-787737]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[-787737]send_query: got id = 'Z'
[-787737]QResult: in DESTRUCTOR
[-787737]QResult: free memory in, fcount=1
[-787737]row = 0, num_fields = 1
[-787737]free [lf=0] 33951568
[-787737]QResult: free memory out
[-787737]QResult: exit DESTRUCTOR
[-787737]CC_connect: returning...
[-787737]szConnStrOut =
'DRIVER={PostgreSQL};DATABASE=lara;SERVER=192.168.1.2;PORT=5432;UID=lara;PWD=xxxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=1;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=1;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=pg_;LFConversion=0;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=2;ByteaAsLongVarBinary=0;UseServerSidePrepare=1'
len=553,1024
[-787737]PGAPI_DriverConnect: returning 0
[-787737][[SQLGetDiagRec]]
[-787737]PGAPI_GetDiagRec entering rec=1[-787737]**** PGAPI_ConnectError: hdbc=32833656 <0>
[-787737]enter CC_get_error
[-787737]enter CC_create_errormsg
[-787737]msg = ''
[-787737]exit CC_create_errormsg
[-787737]exit CC_get_error
[-787737]CC_Get_error returned nothing.
[-787737]PGAPI_GetDiagRec exiting 100
[-787737][SQLGetFunctions][-787737][SQLGetInfo(30)][-787737]PGAPI_GetInfo: entering...fInfoType=23
[-787737]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=2
..
etc

Mikhail.

pgsql-odbc by date:

Previous
From: "Mikhail Umorin"
Date:
Subject: Delphi7, ADO, ODBC and PostgreSQL connection problems
Next
From: Hiroshi Inoue
Date:
Subject: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems