Error connecting ArcMap and Mysql

NishaDevar — Tue, 15 Jul 2014 05:45:04 GMT

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

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

What am I doing wrong ? How do I resolve this

Thank you

Best,

Nisha

Re: Error connecting ArcMap and Mysql

PaulHuffman — Mon, 03 Nov 2014 23:15:27 GMT

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.

topic Re: Error connecting ArcMap and Mysql in Data Management Questions

Error connecting ArcMap and Mysql

Re: Error connecting ArcMap and Mysql