PostgreSQL ODBC - not supported

[sal88]

Hi all

We have a PostgreSQL 9.6.17 database that we wish to connect to from FileMaker. I have added the PostgreSQL Unicode(x64) 9.06.01.00 in to ODBC (64bit) on FileMaker Server and succesfully added a DSN.

From FileMaker Pro this DSN shows and I'm able to add it as an ESS. However when I go to the relationship graph and try to add one of its tables I get the following message:
"The ODBC data source you have selected is not supported."

According to this table it is actually PostgreSQL ODBC Driver (Unicode) 9.03.04.00 that is required. However this is not 64 bit (I tried it anyway but it does not show up at all in ESS in FileMaker Pro):
https://support.claris.com/s/article/Which-ODBC-data-sources-drivers-are-supported-with-External-SQL-Data-Sources-1503692938173?language=en_US

The table also says that we require the Actual Technology Adapter 1.5.0, but I can't work out if that's just for mac.

Any help appreciated.

Many thanks

[jordan.sanders]

Have a look at ODBC Driver for PostgreSQL, I have used it several times and I was satisficed with  the result.