Error connecting ArcMap and Mysql

NishaDevar

Hi,

 

I hope this mail finds you all well. I successfully connected Mysql to ArcMap. How ever in ArcCatalog when I connect to the database it connects and I can view all my tables in the following manner e.g. .bookings. However I can not add them into my map document it says 'Unspecified error'. Also if I try to add data from Add Data->Data Base connections-> DataBaseName the tables are not listed here

 

I performed the following steps to connect to the database

1. ArcCatalog
2. Database Connections
3. Add OLE DB Connection
4. Choose "Microsoft OLE DBProvider for ODBC Drivers
5. Create and add your DSN. You should be able to find your DSN under the "Use data source name" drop down list
6. Put in the same user name and password as above
7. Test Connection - Succesfull

 

 

 

What am I doing wrong ? How do I resolve this

 

Thank you

 

Best,

Nisha

PaulHuffman

I was able to connect MySQL data tables to ArcCatalog and ArcMap 10.0 with this procedure: Connect ArcGIS Desktop to MySQL Database  but I haven't been able to get it to work with Desktop 10.2.2.