Hey, pro 1.1 is extremely promising, lots of good stuff.
We use "Query Layers" (map layers resulting from a SQL Query which returns a shape column).
My database connection works fine in 10.2, but it will not connect in Pro with the same parameters:
I am able to create a query layer from our 2005 SQL server and link shape files to it with an identity field without any error in ArcGIS Pro 1.1. However, if I modify the definition query in ArcGIS or modify the view on the server side the data in my query layer does not refresh. It returns the number of records I'm expecting but the values in all the fields for all the records are blank.
I have to delete and recreate the query layer and then recreate the joins to the shape and layer files.
Should I not be bothering to do this on a 2005 SQL server or am I missing something?
Once I upgraded to SQL Server 2012 SP1 I had no problems with connecting. If you haven't already, I would try that.
That's likely the problem, were on 2008, upgrade to 2012 is in process.
Thanks.
Try installing the SQL Server 2012 Native client from MyEsri or from the Microsoft website and test your connection again.
Download Microsoft® SQL Server® 2012 Feature Pack from Official Microsoft Download Center
Which version of SQL Server are you using? At ArcGIS Pro 1.1 the minimum supported version is SQL Server 2012 SP1. What version of the native client do you have installed?
Microsoft SQL Server database requirements for ArcGIS Pro 1.1—ArcGIS Pro | ArcGIS for Desktop
Just upgraded to 1.1 and I'm getting the same error message, can't figure it out.
Any help is appreciated.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
