How to connect ArcGIS Desktop to MySQL database

23650
3
Jump to solution
12-19-2017 09:08 AM
BobBistrais
Regular Contributor

Can somebody please provide detailed instructions on how to connect ArcGIS Desktop to a MySQL database?  I've seen other threads where people say they've done it.  I have tried it myself, downloaded the ODBC driver, but have not been able to get it to work.  

Tags (3)
1 Solution

Accepted Solutions
KenGalliher1
Esri Contributor

Hi Bob,

I have attached a document that outlines the following:

1.  Download and install the driver.

2.  Add the ODBC driver as a data source on the machine.

3.  Connect to the MySQL database in ArcCatalog.

Here are some relevant links:

MySQL ODBC Driver download (5.2.x)
MySQL :: Download Connector/ODBC 

Adding an OLE DB Connection in ArcGIS Desktop.

Adding OLE DB connections to databases—Help | ArcGIS for Desktop 

- Ken

View solution in original post

3 Replies
KenGalliher1
Esri Contributor

Hi Bob,

I have attached a document that outlines the following:

1.  Download and install the driver.

2.  Add the ODBC driver as a data source on the machine.

3.  Connect to the MySQL database in ArcCatalog.

Here are some relevant links:

MySQL ODBC Driver download (5.2.x)
MySQL :: Download Connector/ODBC 

Adding an OLE DB Connection in ArcGIS Desktop.

Adding OLE DB connections to databases—Help | ArcGIS for Desktop 

- Ken

MichaelVolz
Esteemed Contributor

Is this workflow still relevant in ArcCatalog 10.7.x?  I had an OLE DB connection that still works in 10.5.x, but the MySQL tables do not show up in ArcCatalog 10.7.x when using the same drivers and connection parameters.

0 Kudos
airpanas
New Contributor

I'm using arc catalog 10.8 and it works, but with different version of odbc, see this  MySQL :: Supported Platforms: MySQL Database

0 Kudos