AnsweredAssumed Answered

Connection to Postgress with ESS fails

Question asked by Menno on Jun 13, 2016
Latest reply on Jun 16, 2016 by beverly

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

Outcomes