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

3750
1
01-19-2015 02:15 AM
Highlighted
New Contributor II

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

Reply
0 Kudos
1 Reply
Highlighted
New Contributor II

- We have been creating a view, testing column by column and we made it work.

The issue was that many columns were containing NULL values through all the records and while dragging and dropping the view to ArcMap, it gave the error.

The trick is to replace the NULL values with ("") or spaces (" ") while created the view.

Reply
0 Kudos