Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

User DbExpress to connect to postgresql! This is the
best and fastest way from Delphi.

--

Thomas Wegner

""Mikhail Umorin"" <mikeumo(at)onebox(dot)com> schrieb im Newsbeitrag
news:B0014792881(at)vljcms11(dot)ucmretail(dot)internal(dot)callsciences(dot)com(dot)(dot)(dot)
Hello --
How to set up PostgreSQL ODBC provider so I can access PostgreSQL database
on a LAN? I use ODBC3.0 driver from GBorg (psqlodbc.dll) on WinME and
PostgreSQL 7.3.2 on Mandrake 9.1. So far I tried setting up
File DSN and get rintime error: "Object or provider is not capable of
performing requested operation". (log provided below)I
specified server IP address, database name, user and password in the
provider entry
(through Control Panel) and then used TADOConnection to connect to ODBC
provider. The error comes up when I set Connected property of the connection
object to True.
I do not want to use VitaVoom SQL connection driver as the free (demo)
version requires running Delphi.
Thanks,

Mikhail.

--
Mikhail Umorin
mikeumo(at)onebox(dot)com

here is an excerpt from mylog_xxxx.log (let me know if you need more info):

..
[-240017]READING ATTTYPMOD
[-240017]CI_read_fields: fieldname='pg_client_encoding', adtid=19,
adtsize=64, atttypmod=-1
[-240017]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[-240017]MALLOC: tuple_size = 100, size = 800
[-240017]next_tuple: inTuples = true, falling through: fcount = 101,
fetch_count = 101
[-240017]qresult: len=9, buffer='SQL_ASCII'
[-240017]end of tuple list -- setting inUse to false: this = 33951312
[-240017]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[-240017]send_query: got id = 'Z'
[-240017]QResult: in DESTRUCTOR
[-240017]QResult: free memory in, fcount=1
[-240017]row = 0, num_fields = 1
[-240017]free [lf=0] 33951568
[-240017]QResult: free memory out
[-240017]QResult: exit DESTRUCTOR
[-240017]CC_connect: returning...
[-240017]szConnStrOut = 'DRIVER={PostgreSQL
Legacy};DATABASE=lara;SERVER=192.168.1.2;PORT=5432;UID=lara;PWD=xxxxxxx;Read
Only=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSyste
mTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=
254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=1;UseDeclareF
etch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;Can
celAsFreeStmt=0;ExtraSysTablePrefixes=pg_;LFConversion=0;UpdatableCursors=0;
DisallowPremature=0;TrueIsMinus1=0;BI=2;ByteaAsLongVarBinary=0;UseServerSide
Prepare=0' len=560,1024
[-240017]PGAPI_DriverConnect: returning 0
[-240017][SQLError][-240017]**** PGAPI_Error: henv=0, hdbc=32833656 hstmt=0
[-240017]**** PGAPI_ConnectError: hdbc=32833656 <512>
[-240017]enter CC_get_error
[-240017]enter CC_create_errormsg
[-240017]msg = ''
[-240017]exit CC_create_errormsg
[-240017]exit CC_get_error
[-240017]CC_Get_error returned nothing.
[-240017]**** PGAPI_Error exit code=100
[-240017][SQLGetFunctions][-240017]PGAPI_GetFunctions: entering...0
..

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend