Hi,
I'm trying to write to an ArcGIS SDE database in PostgreSQL. I have:
- FME Workbench 2018.1 64 bit
- ArcGIS Desktop 10.4.1
- ArcGIS Desktop 10.4.1 Background Geoprocessing 64 bit
- ArcGIS Pro 2.2
First, I got this error:
Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set}
I solved this by setting the SDEHOME variable to C:\\Program Files\\ArcGIS\\Pro, so that the 64 bit SDE dll's can be found.
But now I get:
Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.}
The 64 bit PostgreSQL client dll's are in C:\\Program Files\\ArcGIS\\Pro\\bin, but I'm not sure how to instruct FME to use these.