Register mysql Database with Arcgis Server 10.6 Issue

[AdministratorPJN_Sabah]

Hi All,

My problem is as following.

In the GIS server I have installed mysql-connector-odbc-8.0.25-winx64 and mysql-connector-odbc-8.0.25-win32 to connect Arcgis  to mysql DB.
The connection from Arcgis catalog to mysql has been done succesfully, however the moment of register the ODC database with ArcGIS Server I got the following error:
Machine: xxxxxxxx  [MYSQL: General function error] 

Please help. Thanks very much.

[MichaelGinzburg]

Did you installed the odbc connector on the server?

[AdministratorPJN_Sabah]

yes i did

[George_Thompson]

After you added the MySQL clients, did you restart the ArcGIS Server service (or machine) to let it pick up the new clients?

[AdministratorPJN_Sabah]

yes too

[Scott_Tansley]

My SQL?  How are you using it?  Is it just for aspatial data or ar you hoping to use it as an enterprise geodatabase?  Check the support requirements:

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/introduction/geodatabase-administrat...

https://enterprise.arcgis.com/en/server/latest/manage-data/windows/client-geodatabase-compatibility....

[AdministratorPJN_Sabah]

Hi thanks for your reply. Actually, we store inspection data (x,y) in the mysql database. And now I intend to create feature class from the xy data and publish it into our arcgis server. so everytime there's a new point from the mysql data it will reflect in our web application. Is that possible?

Thanks again.

[Scott_Tansley]

So x and y data like that is often stored in seperate fields.  You can see it in an x/y event layer.  It has no spatial indexing as it’s not a spatial type.  It will perform horrendously!  It needs to be exported to a feature class and that needs a file geodatabase, enterprise geodatabase or for you to use the ArcGIS relatiobb no al data store (as part of a full enterprise deployment).  MySQL is not suppirted as an enterprise geodatabase.  Maybe look at PostgreSQL?

[AdministratorPJN_Sabah]

Thanks for your reply sir,

I will look into PostgreSQL then.

Regards.