Looking to connect to MySQL DB from ArcCatalog.
As of now I have ArcCatalog 10.5 running on machine 1. I have a MySQL 8 instance running on machine 2 (server).
I am able to connect to machine 2 from machine 1 via HeidiSQL. I can modify tables, edit users, etc.
I have installed the MySQL OCDB Drivers, done the Microsoft OLE DB Provider for ODBC Drivers in Arc Catalog on machine 1. However, I am unable to connect to the MySQL instance in any fashion.
I am greeted with this error: Test connection failed because of an error in initializing provider. [Microsoft][ODBC Driver Manager] Invalid connection string attribute.
This error leads me to believe that I might have typed something wrong. However, I'd like to not use the connection string at all; ideally, it would show me the MySQL instance in the Data Source Name drop down box.
When I load ArcCatalog on machine 2 I see my DBs in the drop down box.