Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA29358 for ; Wed, 17 Nov 1999 08:32:41 -0500 (EST) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.9.3/8.9.3/NETTuno 3.3) with ESMTP id OAA24900; Wed, 17 Nov 1999 14:32:03 +0100 (MET) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 11o6u9-00017Y-00; Wed, 17 Nov 1999 15:21:53 +0000 Message-ID: <3832AEEB.4214066D@sferacarta.com> Date: Wed, 17 Nov 1999 14:34:36 +0100 From: jose soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: maxsbox CC: pgsql-sql@hub.org Subject: Re: [SQL] ODBC/Openlink/Delphi References: <38319FA3.777F2EEA@scds.co.za> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit What you need is the right ODBC driver try at: http://www.insightdist.com/psqlodbc I tried Openlink ODBC driver for PostgreSQL some time ago and it seems to me very updated. José maxsbox ha scritto: > I have been trying to connect, first Delphi2 and then C++Builder3, to > postgresql via Openlink ODBC. The client for Win95 was downloaded from > openlinksw.com and the server end came packaged with SuSE 6.2 along with > postgresql 6.4 > > Results are identical for both. The data base is logged on, the > file structure is returned and the table DBGrid is set up. The data is > not brought across however and the following message box is brought up > > Error > Project Project1.exe raised exception class EDBEngineError with message > 'General SQL error. [Openlink][ODBC][Driver]Driver does not support this > > function'. Process stopped. Use Step or Run to continue. > > The same occurs when using an SQL icon and attaching a simple select > request to it. > > Openlink seem to be a pretty solid distribution and have been very > helpfull to date - They are still looking at the problem, but I gain the > impression that Postgresql is a little out of the main stream for them. > > The postgres works very well and I have no problems accessing it using > telnet either with psql or pygres from win95. > > If someone out there is using such a set up and can offer some advice, I > will be delighted to hear from them. It is so close to working that it > can only be some small problem stopping the return of the required data. > > Incidentaly neither the Delphi or C++Builder is the Client/Server > version. I understand, however that even the Professional version > should allow connectivity. It does not allow browsing, which is not > necessary if you know what files are there and type them in. > > regards > > Max Wood > > ************