Is it possible to connect to PostgreSQL via ODBC in Delphi 7?

Navigation
1

I'm having a hard time connecting to the PostgreSQL database in Delphi 7 , I got it with Zeos Lib, however I need it to be via dbExpress the connection, then I saw that in the most current versions of Delphi it is possible to connect via ODBC , but Delphi 7 does not offer this option, What component do I need to add in order to make such a connection via ODBC in Delphi 7 ?

    
asked by anonymous 26.10.2016 / 13:40

1 answer

2

R. Santos to use ODBC connection it is necessary to use the ADO components, with which it is possible to connect through PostgreSQL lib odbc.

To get started, download the postgresql lib odbc link

Then add an ADOConnection component to your project and configure the ConnectionString property by selecting the PostgreSQL OLE Provider provider and filling in the remaining options available for connecting to the database.

Once this is done, enable ADOConnection and place an ADODataSet, specify the SQL command, and you can use it alone or in conjunction with the dataset provider + clientdataset.

    
02.11.2016 / 02:04
Import CSS files with SASS Error trying to add updated Fields in ClientDataSet