Error connecting ArcMap and Mysql

3089
1
07-14-2014 10:45 PM
Highlighted
New Contributor

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

Reply
0 Kudos
1 Reply
Highlighted
Occasional Contributor III

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.

Reply
0 Kudos