topic Re: How to get server 10.2.1 to see MYSQL table in ArcGIS Enterprise Questions

How to get server 10.2.1 to see MYSQL table

AaronGruber — Fri, 21 Mar 2014 20:47:11 GMT

I have many layers that have joins to MYSQL tables. I have all the ODBC connections set up in Arc Catalog, and in Arc Map everything works as it should. When I go to publish the service it wants me to register the databases. When I try to register it, it comes back with 'error: general function failure'. I have tried to register the database from manager, but when I import the connection file it just hangs until I close it. Any help would be very appreciated.

Re: How to get server 10.2.1 to see MYSQL table

WalterKuong_-_DIT — Tue, 06 Jan 2015 23:16:21 GMT

Hi, did you get your problem solved? I have the same problem. Thanks,

Re: How to get server 10.2.1 to see MYSQL table

AaronGruber — Wed, 07 Jan 2015 00:00:33 GMT

Is your server on a Linux or Windows box?

Sent from my Samsung Galaxy S®III

Re: How to get server 10.2.1 to see MYSQL table

WalterKuong_-_DIT — Wed, 07 Jan 2015 00:23:22 GMT

I have server on Windows 2008 R2 64 bit.

Walter Kuong

Enterprise GIS Technology

Department of Information Technology

(808) 768-7602

Re: How to get server 10.2.1 to see MYSQL table

AaronGruber — Wed, 07 Jan 2015 02:06:34 GMT

From the administrative tool, open the 32 and 64 bit odbc Data sources and create identical UserDSN to your mysql in each one, and it should work.

Re: How to get server 10.2.1 to see MYSQL table

AaronGruber — Wed, 07 Jan 2015 02:17:58 GMT

You have to make sure you have both the 32 and 64 bit odbc drivers and then with creating identical sources with them the 64 bit server and the 32 bit client can both see mysql.

Re: How to get server 10.2.1 to see MYSQL table

WalterKuong_-_DIT — Wed, 07 Jan 2015 02:31:16 GMT

I installed both MySQL 5.3.4 32bit and 64bit driver. I am able to create an ODBC connection file from ArcCatalog, and I am able to see the table in MySQL. Nevertheless, I cannot use the ODBC connection file to register database in the datastore in ArcGIS server 10.2.2. ArcGIS server gave me "General function failure".

Re: How to get server 10.2.1 to see MYSQL table

SusanJones — Wed, 07 Jan 2015 03:05:12 GMT

Does the ARcGIS Service Account have permissions to the MySQL Database?

Which user are you using to create the ODBC Connections?

Re: How to get server 10.2.1 to see MYSQL table

AaronGruber — Wed, 07 Jan 2015 03:10:46 GMT

That was the same exact problem I was having. It is because when you create the connection from catalog it is only creating the 32 bit connection and server does not know what to do with it. If you create your connections from windows first by creating the same connection for 32 and 64 bit then when you select it from catalog you should be able to register it in the datastore

Re: How to get server 10.2.1 to see MYSQL table

AaronGruber — Wed, 07 Jan 2015 03:20:46 GMT

I never set up any permissions in mysql. I used the same user for everything.

Re: How to get server 10.2.1 to see MYSQL table

WalterKuong_-_DIT — Wed, 07 Jan 2015 19:11:26 GMT

These are the steps that I have done on a Windows 2008 R2 64 bit server. Both 32 and 64 bit MySQL ODBC drivers have been installed.

1. use the 64 bit odbcad32.exe in %systemdrive%\Windows\System32 folder to create ODBC data source under User DSN.

2. use ArcCatalog to add OLE DB connection and selected the ODBC source created in step 1. ArcCatalog has no problem creating the odc connection file and no problem connecting to MySQL DB. However, ArcGIS server complained "general function failure" when importing this odc connection file in step 1 to register in datastore.

3. use the 32 bit odbcad32.exe in %systemdrive%\Windows\SysWoW64 folder to create ODBC data source under User DSN.

4. use ArcCatalog to add OLE DB connection and selected the ODBC source created in step 3. ArcCatalog has no problem creating the odc connection file and no problem connecting to MySQL DB. However, ArcGIS server complained "general function failure" when importing this odc connection file in step 3 to register in datastore.

Re: How to get server 10.2.1 to see MYSQL table

AaronGruber — Wed, 07 Jan 2015 20:20:29 GMT

If you open the 32 and 64 bit ODBC panels side by side, and create one in the 32 bit user DSN, it will show up in the 64 bit user DSN, but you still have to add one to the 64 bit with the same exact name, description, and connection properties as you did for the 32 bit.

After I did that I quit getting the general function failure.

Re: How to get server 10.2.1 to see MYSQL table

PaulHuffman — Mon, 27 Apr 2015 21:55:01 GMT

I was able to link MySQL tables to Desktop 10.0, but not 10.2.2. ESRI Customer Care told me in Feb. 2015 that it was no longer possible with 10.2.2. https://community.esri.com/thread/10539 However, I haven't tried the 32 bit MySQL ODBC drivers with 10.2.2. On a Windows 7 64 bit system, there is a executable that allows us to set up connections with the 32 bit drivers at C:\Windows\SysWOW64\odbcad32.exe.

Dang! It works to use the 32 bit user DSNs to MySQL 5.1 data sources, same as it did for me under Desktop 10.0! A period appears in front of all my table names.

Re: How to get server 10.2.1 to see MYSQL table

williamcarr — Mon, 13 Jun 2016 20:30:30 GMT

Exact same issue. Did you ever have any luck?