AnsweredAssumed Answered

Drag and drop a view created from MS SQL Server 2008 R2 into ArcMap (ArcGIS for Desktop 10.1 SP1)

Question asked by Reda20 on Jan 19, 2015
Latest reply on Jan 20, 2015 by Reda20

While I am dragging and dropping a view freshly created by the database administrator in a enterprise geodatabase hosted in MS SQL Server 2008 R2, in ArcMap 10.1, I am choosing the ID only:

1. NEWQUERYLAYER.png

and I am getting the following error, that I cannot define:

2. tableview.png

 

I have tried to access it through a "MakeQueryTable" process as well but I am getting the following error again:

3. MAKEQUERYTABLE.png

 

Tech. Specs:

- MS SQL Server 2008 R2.

- ArcMap 10.1(ArcGIS for Desktop 10.1 SP1)

- MS SQL Server Native Client 10.51.2500.00

Outcomes