1

I received info to connect to a database (without a spatial component) that has tables I need for a project I'm working on. Problem is once I establish the connection in ArcCatalog I can see all of the tables contained in the database, but when I try to open all the fields are there but they aren't populated with any information. The person who created them says it looks good on his end.

I attempted to export one of the tables to a .dbf file and it gave me a 999999 error with a 000592 warning.

  • 2
    Please edit the question to specify the version of ArcGIS in use, the database product, and the version of the database product. A description of the fields (name & type) would also be necessary. – Vince May 16 '16 at 17:29
  • 1
    do the tables contain spaces or non alpha-numeric characters in the table-names or field-names? – Midavalo May 16 '16 at 18:13
  • Another thing to consider is if you have permission to view the contents of the tables. I think I have run into issues logging in under one schema where I couldn't access contents created/owned under another schema. – Branco May 16 '16 at 19:20
  • Have you tried restarting your computer? Seriously. Also, what kind of server are you connecting to? Troubleshooting is different depending on if it's Oracle, Microsoft SQL Server, open source, etc. – denim_dan May 16 '16 at 20:49
  • 1
    Your error message is associated with mistakenly trying to write datatype(s) not supported by shapefiles. Exporting from database to shapefile is sufficently horrific that it should be avoided at any cost. – Vince May 16 '16 at 23:06
1

You need to ask the dbo/ sys admin to database you have read permissions for all tables in the required database.

0

This may not be the source of your problems, but make sure the "show all records" icon is selected.

enter image description here

Otherwise the row values will be shown for only the rows that have been selected.

enter image description here

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.