ADD OLE DB CONNECTION ARCGIS 10.3 UPGRADE
ADD OLE DB CONNECTION ARCGIS 10.3 PRO

I am scared to even think that this will work across all databases and ArcGIS servers.В Cross my fingers! I tested the service in one of our web mapping applications by adding the service URL to the configuration file, and I was able to query and display the data on the map. Publishing took not more than 30 seconds. I registered the new connection in the ArcGIS Server Data Store and published the. Data drew very fast (with all these Index Seeks ). This time, the creation of the layers was instantaneous, a few seconds. odc connection in ArcMap to add the tables with XY columns and create XY event layers. Once the connection was created, I had to close and open ArcCatalog to see it and rename it. I created an OLE DB connection using the option 'Microsoft OLE DB Provider for SQL Server' (the SQL Server Native Client option didn't work, it wouldn't show any tables).

And the database is not aВ geodatabase.ДЄnd it hit me, maybe I should try an OLE DB connection as opposed to the. If you have found a solution, please, advice!ДЄs the ESRI representative was suggesting things to try and asking questions after I created a trace for her to see what is going on, one of her questions was about SDE related tables inquiries in the trace.

ADD OLE DB CONNECTION ARCGIS 10.3 UPGRADE

We have been holding on to 10.3.1 for dear life, but with the upgrade of the OS we have to move on, and it doesn't look pretty.

ADD OLE DB CONNECTION ARCGIS 10.3 PRO

I am currently testing the same scenario in ArcGIS Pro 2.3, and it has been running for hour and a half the process of creating an XY event layer from the view with 100K. None of these are possible, so I am turning to you, guys, for help. I have opened a case with ESRI, and so far the solutions I have been given are to enable that database as a geodatabase or export the data to a geodatabase (which took 45 minutes). Still it took 30 minutes to create the XY layer with the view with the least records. I added more indexes and made sure I only have 'Index Seeks'. If layer is successfully added, then publishing runs for a long time (30 minutes +) and fails. The final record count of the views is 100K-500K.ДЄdding one of these views to ArcMap is fairly quick, but displaying as XY event layer takes hours if the application doesn't crash. Some of the views join multiple tables with millions of records. We have number of views coming from a non-spatial SQL Server 2016 database that we publish to ArcGIS server. Problem: Performance of SQL Server views degrades after upgrading to ArcGIS 10.4ДЄt version 10.6.1 this is still the same. This is the technical article describing the problem:

Add ole db connection arcgis 10.3