delphi connection

[prgaray]

Hi, my company has a client that uses a progress database. version 10.x
We need to connect to this database and import/export data through our application.
Does anyone knows how to do it? With a odbc connection??
We use Delphi 7 and oracle/postgre/sqlserver databases.

Thanks,

Pablo Garay
Desenvolvimento IONICS
http://www.ionics.com.br

 

[tamhas]

ODBC or JDBC would be the usual thing. If you look at the child pages attached to this entry http://www.oehive.org/node/952 it should give you the outlines of an idea of how to do the setup. There are both server and client setup requirements, so it will partly depend on whether they have already set up the database for SQL access. There is an option on install to support 4GL only or 4GL and SQL clients, so if they have picked the 4GL only they may have some adjusting to do. Depending on load, the nature of their clients, etc., it may also be necessary for them to start a secondary broker for SQL. There are whitepapers on PSDN that cover this stuff. Once they have their end set up, the client side is pretty straightforward.

 

[prgaray]

Thank you for your answer. It was very helpful.
We were able to establish the connection using the proenv tool.