Delphi7, ADO, ODBC and PostgreSQL connection problems

From: "Mikhail Umorin" <mikeumo(at)onebox(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Delphi7, ADO, ODBC and PostgreSQL connection problems
Date: 2003-09-16 20:40:24
Message-ID: B0014792881@vljcms11.ucmretail.internal.callsciences.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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;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
..

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Kris Jurka 2003-09-16 23:17:43 Re: observations about temporary tables and schemas
Previous Message Tom Lane 2003-09-16 18:55:14 Re: observations about temporary tables and schemas