Re: [SQL] ODBC/Openlink/Delphi

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
>
> ************