Skip to main content
Question

How to connect to PostgreSQL / SDE

  • November 21, 2018
  • 1 reply
  • 69 views
bveldkamp

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

bveldkamp
  • bveldkamp
  • Author
  • November 21, 2018

A few moment after posting I found the answer: I added C:\\Program Files\\ArcGIS\\Pro\\bin to the system's PATH variable, and now the client libs can be found.

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.