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@onebox.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;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;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=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
..