topic Re: Register mysql Database with Arcgis Server 10.6 Issue in ArcGIS Enterprise Questions

Register mysql Database with Arcgis Server 10.6 Issue

AdministratorPJN_Sabah — Thu, 03 Jun 2021 05:20:38 GMT

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.

Re: Register mysql Database with Arcgis Server 10.6 Issue

MichaelGinzburg — Thu, 03 Jun 2021 18:05:25 GMT

Did you installed the odbc connector on the server?

Re: Register mysql Database with Arcgis Server 10.6 Issue

George_Thompson — Thu, 03 Jun 2021 18:35:11 GMT

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

Re: Register mysql Database with Arcgis Server 10.6 Issue

Scott_Tansley — Thu, 03 Jun 2021 23:30:13 GMT

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-administration.htm

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

Re: Register mysql Database with Arcgis Server 10.6 Issue

AdministratorPJN_Sabah — Fri, 04 Jun 2021 05:05:00 GMT

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.

Re: Register mysql Database with Arcgis Server 10.6 Issue

AdministratorPJN_Sabah — Sat, 05 Jun 2021 02:18:30 GMT

yes i did

Re: Register mysql Database with Arcgis Server 10.6 Issue

AdministratorPJN_Sabah — Sat, 05 Jun 2021 05:33:41 GMT

yes too

Re: Register mysql Database with Arcgis Server 10.6 Issue

Scott_Tansley — Sat, 05 Jun 2021 18:06:33 GMT

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?