I am trying to connect a FMServer 15 (using a FMPA15-client) to a postgress-db with ESS.
I have installed the progress-odbc-driver 9.03.04.00 as indicated in the help information: Which ODBC data sources/drivers are supported with External SQL Data Sources? | FileMaker and I installed the actual ESS adaptor 1.0.3 from Actual_ESS_Adapter_Windows.zip (for Windows)
I have attached some screenshot that clearly show that the drivers all work and that connection to the pg-database work, but the connections fails as soon as I select the "ActualTech" driver/DSN.
Does anyone understand what is going wrong?
In the manage ODBC 64-bit on the computer the PostgreSQL35W is chosen
and tested and as you can see the connection is tested succesfully:
After that the Actual ESS adapter is configured with the previously created an d tested PostgreSQL35W DSN:
That connection is also tested and also appears to work fine:
For your info, i have included the setup-information:
Chosen DSN:
Which is configured here in manage EDS panel:
So it is now available:
In teh manage database screen a new table is added and the specify-table does not react for a minute or so:
after which this error occurs:
I hope anyone of you can tell me what is wrong
Thank you, Menno
I think the problem might be that the Actual ESS Adapter requires a license key when it is used with FileMaker Server. You can get a 30-day evaluation key from our website:
http://www.actualtech.com/register.php
After you install the license key, you should restart FM Server.
Jonathan Monroe
Actual Technologies - ODBC for macOS