AnsweredAssumed Answered

Publishing MapService, using ArcMap document with ODBC to MySQL Table

Question asked by ljacedo on Nov 23, 2017
Latest reply on Sep 12, 2018 by ljacedo

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

Attachments

Outcomes