Thread: ODBC/Openlink/Delphi
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
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 > > ************