Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
    
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. –  npo Jun 22 '12 at 4:26

1 Answer 1

up vote 8 down vote accepted

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.

share|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. –  npo Jun 22 '12 at 5:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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