1

I have a database on PostgreSQL 9.5 when I try to connect to the database in ArcGIS desktop I get this message in log:

CAN'T OPEN INSTANCE: sde:postgresql. Spatial Engine Connection Failed (-51)

After that I have an error:

ev.SQLstate = 42501 SDE DBMS Error: -25 ERROR: must be owner of database base ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist LINE 1: select count(*) from sde.sde_layers

File pg_hba.conf changed and users have CONNECT privileges.

What is the problem?

I'm following Esri instruction.

nmtoken
13.7k5 gold badges39 silver badges91 bronze badges
asked Jan 19, 2018 at 7:51

1 Answer 1

1

The problem was in ODBC driver. After installing proper driver version -x86, connect have created. But One problem still remains - ArcGIS desktop doesn't recognize spatial objects in tables. There is a geometry type field in table, but it recognizes as String

answered Jan 19, 2018 at 14:36

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.