Hello,
I am trying to connect to our Enterprise Geodatabase. This used to work for quite a long time using FME 32 bit (several older FME versions). Using FME 64 bit (on the same machine) produced an error like this:
Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {Keine No SDEHOME-Umgebungsvariable festgelegt}
Please ensure the connection parameters are correct (server=`sde', instance=`....', user=`....', password=`***', database=`', version=`SDE.DEFAULT')
Now we have FME 2020.2 64 bit and I don't have the 32 bit version anymore.
I created a database connection file (*.sde) using ArcCatalog on my machine. There, I can see the database and connect to it. I can also open the connection in ArcCatalog directly using my sde file. But I can't use the same connection file to connect a reader (Format: Esri Geodatabase (ArcSDE Geodb Raster Dataset)) in FME. Three colleagues did this (same network, same database, same software, same connection file) and it worked for them.
Since it claims it wants a SDEHOME environment variable (that's what the german part of the above message says), and even though my colleagues do not have this environment variable, I created one and pointed it to C:\\Program Files (x86)\\ArcGIS\\Desktop10.6\\bin (I also tried the path without the bin part). Didn't work, but new error message:
Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Zur Datenbank kann nicht verbunden werden, da das Laden der Datenbank-Clientsoftware fehlgeschlagen ist. Stellen Sie sicher, dass die Datenbank-Clientsoftware richtig installiert und konfiguriert ist.}Please ensure the connection parameters are correct (server=`sde', instance=`...', user=`...', password=`***', database=`', version=`SDE.DEFAULT')
(My translation: Can not connect to database, because loading the database client software failed. Make sure you installed and configured the database client software.)
I do not think that this is a bug, since it works for my colleagues, but I ran out of ideas where to look for differences in our setup. So any help will be greatly appreciated.
Kind regards
Norbert