Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From: "Mikhail Umorin" <mikeumo(at)onebox(dot)com>
To: mikeumo(at)onebox(dot)com, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Date: 2003-09-16 23:34:25
Message-ID: B0015232795@vljcms10.ucmretail.internal.callsciences.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 here is 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.

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-09-17 00:02:52 Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Previous Message Kris Jurka 2003-09-16 23:17:43 Re: observations about temporary tables and schemas