I have a large database in Filemaker. To get this joined with a feature class in ArcGIS I have to make an ODBC connection. I do this in the 32-bit ODBC in windows because ArcGIS is 32-bit. In Arccatalog I then have to make an Oledb connection to the ODBC to get the table translated in ArcGIS.
This seems to work up until the point I want to add symbology based on the joined table. The text fields can't be used to add symbols. The number fields do work and the table does show the values correctly.
- the text fields sometimes contain 1000000 characters
- could there be an office involvement?
What could be going wrong?
ArcGIS 10.3.1 Filemaker 14 Windows 7 (64-bit)