Re: Delphi and PostGreSQL





Hello Mike,
I have had exactly the same problem to resolve.
Many people told me that I have to use DAC PostgresSQL which is a special third party component.
But after some trials, probably as well due to some SQL dialect problems (not allways easy with PSQL)I decided to take ADO components. Of course an odbc driver must be installed.
I had problems to use ADO before but after importing data in ACCESS and having a dsn file everything worked well.

I recommend ADO.


Thomas Willms



"mikey" <noone@xxxxxxxxxxx> wrote:
Hi all
I'm doing a low / no budget project (community based) which requires a
reasonably large amount of data to be available remotely.
At this stage I've half written the front end in delphi 7 and am looking at
Postgresql on Linux for the back end.

Can anyone advise a reliable and not too expensive (or free) data access
component for delphi / postgresql ?

Mike



.



Relevant Pages

  • Re: [VB?] & Java ...
    ... "automatische" Datenbindung mittels ADO. ... was aber später unter Linux Probleme gibt. ... der derzeit erstmal mit SQLite funktioniert und z.B. ... auch auf PostgreSQL zugegriffen werden kann. ...
    (microsoft.public.de.vb)
  • Re: Alternative zu Fox Pro gefunden Erfahrungsbericht
    ... automatisieren lässt - aber da werde ich mich schon durchfinden. ... Delphi arbeitet äquivalent VFP mit DBx Datenbanken. ... Alternative zu VFP. ... Ansonsten: Nimm PostgreSQL. ...
    (microsoft.public.de.fox)
  • Re: Postgresql 8.1 released
    ... Marcello Dias wrote: ... > PostGresql have a much better architecture than many ... > comercial products(I mean SQL SERVER,SYBASE others). ... I have a small experience in Delphi and IB in developing small desktop ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: .NET or not - any difference
    ... Well, conversely, it's not the availability of skilled Delphi software ... Yeah, but to get the best and the most out of PostgreSQL, it needs to ... stick to existing platforms - most common being SQL Server. ...
    (borland.public.delphi.non-technical)
  • [ANN] PG Lightning Admin 1.2.3.1011 released (for Postgresql)
    ... If you are a Delphi user and have any interest in using Postgresql, be sure to check our app out, it provides a MUCH better user experience ... Editorsare now UNICODE enabled thanks to the Unisynedit Delphi component. ... For more information on PG Lightning Admin and the screen cam demos please see: http://www.amsoftwaredesign.com/lightning_admin.php ...
    (borland.public.delphi.thirdpartytools.general)