I recently connected a MySQL database to ArcGIS by adding an OLE DB Connection. I can view the tables just fine; however, my XY data will not show up on the map directly from the MySQL table, I have to export the data to a standalone File Geodatabase table first, and then display the XY Data. Is this normal?
It seems like it sort of defeats the purpose of dynamic data tables. I wanted to directly manipulate the MySQL tables in ArcGIS so that changes I make to the attributes in ArcGIS are reflected on the MySQL database and vice versa.
This brings me to my real question. I was unable to locate any detailed documentation concerning:
What are the limitations of using MySQL through an OLE DB Connection with ArcGIS?
I found an inkling on the limitations from this post.
Establishing a MySQL connection in ArcGIS 10 ". . geometries from the Spatial extension will not come through to the GIS."
Can anyone tell me where I can find out more? Should I just switch to Microsoft SQL for use with ArcGIS?