Register mysql Database with Arcgis Server 10.6 Issue

943
8
06-02-2021 10:20 PM
AdministratorPJN_Sabah
New Contributor II

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.

0 Kudos
8 Replies
MichaelGinzburg
Occasional Contributor II
Did you installed the odbc connector on the server?
0 Kudos
AdministratorPJN_Sabah
New Contributor II

yes i did

0 Kudos
George_Thompson
Esri Frequent Contributor

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

--- George T.
0 Kudos
AdministratorPJN_Sabah
New Contributor II

yes too

0 Kudos
Scott_Tansley
Occasional Contributor III

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

 

 

Scott Tansley
Consulting Architect (ArcGIS Enterprise)
https:///www.geoworx.co.nz/
https://www.linkedin.com/in/scotttansley/
0 Kudos
AdministratorPJN_Sabah
New Contributor II

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.

0 Kudos
Scott_Tansley
Occasional Contributor III

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?

Scott Tansley
Consulting Architect (ArcGIS Enterprise)
https:///www.geoworx.co.nz/
https://www.linkedin.com/in/scotttansley/
AdministratorPJN_Sabah
New Contributor II

Thanks for your reply sir,

I will look into PostgreSQL then.

 

Regards.

0 Kudos