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.
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:
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?
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?