5

Is it possible to create a connection to a MySQL database in ArcGIS 10?

  • Do you want spatial features, or just text/numeric data tables? – Mike T Jun 22 '12 at 3:40
  • Mostly just the tables. I guess the spatial features would be nice, but not essential for now. I've noticed the spatial data types when setting the table field definitions, but never investigated how they work. – hendra Jun 22 '12 at 4:26
11

If all you need is the tables of IDs, text, numbers (no geometries), then your best option is to use ODBC. You can install a MySQL ODBC driver for your system: http://www.mysql.com/downloads/connector/odbc/ download "Windows (x86, 32-bit), MSI Installer". (ArcGIS is still a 32-bit program, even on a 64-bit computer, so you will always require a 32-bit driver to match).

Then create a DSN for your database, here are some instructions for MySQL. If you are on a 64-bit computer, you need to ensure that you are using the 32-bit version of "ODBC Data Source Administrator", which is found at C:\Windows\SysWOW64\odbcad32.exe.

Once you have successfully created and tested the DSN connection, you can add it to ArcGIS. In ArcCatalog, go to "Database Connections", "Add OLE DB Connection". Choose "Microsoft OLE DB Provider for ODBC Drivers", and you should be able to find your DSN under the "Use data source name" dropdown list. Test connection, and you should be good to go. You can join these attributes in ArcMap to other features using common IDs, etc.

However, geometries from the Spatial extension will not come through to the GIS. You would probably need to export these as another spatial format recognized by ArcGIS.

| improve this answer | |
  • Excellent! Thankyou. I was using the wrong version of the driver, and I didn't know I had to set up a DSN. – hendra Jun 22 '12 at 5:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.