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
