Publishing MapService, using ArcMap document with ODBC to MySQL Table

[LuisAcedo]

Im having a problem publishing a dynamic table with UTM X,Y fields and other fields. The problem is MapService does not present the correct value for each row, but it does display all points on map.

The MapService is create with ArcMap document 10.2, the layer is a ODBC layer connected to a MySQL 5.3. I'm able to import the layer into ArcMap, defined the coordinated fields and create a map point feature layer within ArcMap. I'm also able to publish this layer to ArcGIS Server 10.5, and the layer is visible and quera-ble.

If you have an idea of how to solve this problem please let me know

Thanks

Luis Acedo

If you open the attaches images, you will see that ArcCatalog display all field. Following is the display of a query result asking for all feature on same layer though MapService.

# records: 4

ID: null
INDICATIU: 505
CONDUCTORS: 11/23/2017 1:53:24 PM
DATAHORAGPS: -2191708800000
RUMB: 41.5283
LATITUD: 2.16427
LONGITUD: 430278
UTMX: 4597743
UTMY: null
DATAHORAGPS80: null
KM: null
LITRES: null
OBJECTID: 374

ID: null
INDICATIU: 1543, 1526
CONDUCTORS: 11/23/2017 1:48:23 PM
DATAHORAGPS: -2193609600000
RUMB: 41.817298
LATITUD: 2.842888
LONGITUD: 486951
UTMX: 4629503
UTMY: null
DATAHORAGPS80: null
KM: null
LITRES: null
OBJECTID: 1004

ID: null
INDICATIU: 1299
CONDUCTORS: 11/23/2017 1:56:11 PM
DATAHORAGPS: -2193609600000
RUMB: 41.817266
LATITUD: 2.84293
LONGITUD: 486955
UTMX: 4629500
UTMY: null
DATAHORAGPS80: null
KM: null
LITRES: null
OBJECTID: 1278

ID: null
INDICATIU: 1290
CONDUCTORS: 11/23/2017 1:56:45 PM
DATAHORAGPS: -2205273600000
RUMB: 41.637516
LATITUD: 2.407608
LONGITUD: 450662
UTMX: 4609701
UTMY: null
DATAHORAGPS80: null
KM: null
LITRES: null
OBJECTID: 2061

[GiosiaPoma]

Hi Luis,

I don't understand your problem.

I've created a similar mxd as your. I've registered data storage on arcgis server (odc file) and when I try to publish the mxd to the server ArcMap crash. All of the software is 10.5.0.

On the arcgis server I've installed mysql odbc (64bit) and defined the dsn, registered the odc file on arcgis server, but on the publish process I have the crash.

Have you suggestions? After that, If the publishing process work, I can help you.

Regards

[LuisAcedo]

Hi Giosia,

The problem I´m having is that I can see the point on the map with UTM coordinates 25831. However when I query a point or select the point, it does not show the geometry values, ether point or the values on UTMX and UTMY.

On the query result, the values UTMX, UTMY should show a value as it is on the database. But it does not show when I do a query over the map service.

That is the problem I´m having

Thanks

Luis Acedo