Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
От | Mikhail Umorin |
---|---|
Тема | Re: Delphi7, ADO, ODBC and PostgreSQL connection problems |
Дата | |
Msg-id | B0015232795@vljcms10.ucmretail.internal.callsciences.com обсуждение исходный текст |
Ответ на | Delphi7, ADO, ODBC and PostgreSQL connection problems ("Mikhail Umorin" <mikeumo@onebox.com>) |
Список | 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 по дате отправления: