5 Replies Latest reply on Jun 16, 2016 8:18 AM by beverly

    Connection to Postgress with ESS fails

    Menno
    Menno Jun 13, 2016 2:13 AM

      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

      SSTS06_ODBC_DSN_setup.png

      and tested and as you can see the connection is tested succesfully:

      SSTS07_DriverTest.png

      After that the Actual ESS adapter is configured with the previously created an d tested PostgreSQL35W DSN:

      SSTS08_DSNchoice.png

       

      That connection is also tested and also appears to work fine:

      SSTS09_ConnectionTest.png

       

      For your info, i have included the setup-information:

      SSTS10_DSNconfig.png

       

      Chosen DSN:

      SSTS01_SelectODBC.png

      Which is configured here in manage EDS panel:

      SSTS02_EditDataSource.png

      So it is now available:

      SSTS03_ManageExternalDS.png

      In teh manage database screen a new table is added and the specify-table does not react for a minute or so:

      SSTS04_SpecifyTable.png

      after which this error occurs:

      SSTS05_ErrorMessage.png

      I hope anyone of you can tell me what is wrong

       

      Thank you, Menno