nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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: xyz [MYSQL: General function error]

Please help. Thanks very much.

ERROR MYSQL.jpg

2024-05-09_12-51-32.png

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

MichaelGinzburg

Did you installed the odbc connector on the server?

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?

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

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

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.

AdministratorPJN_Sabah

yes i did

AdministratorPJN_Sabah

yes too

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.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.