Has anyone successfully used the ODBC Dataserver to connect and update a PostgreSQL database? I need to be able to create a schema and update and read tables in a PostgreSQL DB. Progress support told me that although I can try using ODBC Dataserver it is not certified. Yet, given that here are knowledge base articles talking about different types of issues I assume that someone out there has done this.
GTR Data Inc.
David Moloney, do you know of any customers currently doing this?
I would also know some about connect to postgresql from a Progress program.
What version of Progress? What do you need to do? There are three solutions that I can think of:
1. The ODBC DataServer does not officially support Postgres but I have made it work with the help of Marek.
2. In 11.x there is an ODBC class that you can probably use with a Postgres ODBC driver though I haven't tried it myself.
3. If it's really not a lot of queries and performance is unimportant, you can easily write a little PHP program and run it using INPUT THROUGH mypostgresquery.php.