7

I have a plain postgressql table (version 8.2). I am trying to connect to it to it from ArcGIS desktop 10.0, and use as a query layer, as given in this document: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Connecting_to_a_database/00s500000037000000/

I can see the tables, but I get the error message 'DBMS table not found' enter image description here

What exactly is the issue? How do I connect to it?

5

Here is the solution that I found. My Table's names contained capital letters. Once I used a table with the name in all small letters, I got no error message, and could use the Query layer.

Aside

How did if find out this is the cause, you ask? I was searching for Postgresql and Query layers, and I found this post on the ArcGIS Forums, which says that ArcGIS has problems connecting to Databases with capitals in their name.

My database did not have capital letters in the name, but the Tables did have. You can even see that in the "List of Tables Window", ArcGIS list the table with names in all small.

This is probably why it gives the error message saying 'DBMS table not found' since in the query it tries to find a table with names is all small, which does not exist.

2

If by plain table, you mean a table without spatial information you don't need a query layer, you can use an OLE connection. You can then use that OLE connection to connect to the table and add it to your map document making it available for joins to your other layers.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006m0000006p000000.htm

  • An oleDb connection has several limitations. And I'll ideally like to make joins in the query and use the result. – Devdatta Tengshe Apr 10 '13 at 15:05
  • 1
    @DevdattaTengshe I think you should encapsulate data concerns at the data layer. Use an OLE connection to query a view that handles all your table relations. In a perfect world your GIS shouldn't need to know how your database schema is structured. – tomfumb Apr 10 '13 at 15:59
  • @tomfumb: Query Layers in ArcGIS are meant for exactly the user case I am describing. ArcGIS will function as a client for the RDBMS, just like PgAdmin. They are great for one off dynamic queries. In the case when there queries will be used again and again, yes a view will be better. – Devdatta Tengshe Apr 11 '13 at 5:06
  • @tomfumb And In my perfect world, I would be able to use ArcGIS Desktop(or any other software) to work with any data source, be it shapefiles, Rasters, Geodatabases, .xls, geoJson, RDBMS, csv etc in a single software. ArcGIS isn't there yet, but it is getting there. – Devdatta Tengshe Apr 11 '13 at 5:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.