How to get server 10.2.1 to see MYSQL table

[AaronGruber]

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.

[WalterKuong_-_DIT]

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

[AaronGruber]

Is your server on a Linux or Windows box? 

Sent from my Samsung Galaxy S®III

[WalterKuong_-_DIT]

I have server on Windows 2008 R2 64 bit.

Walter Kuong

Enterprise GIS Technology

Department of Information Technology

(808) 768-7602

[AaronGruber]

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.

[AaronGruber]

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.

[WalterKuong_-_DIT]

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".

[AaronGruber]

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

[WalterKuong_-_DIT]

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.

[williamcarr]

Exact same issue. Did you ever have any luck?