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

El_BoukfaouiReda — Mon, 19 Jan 2015 10:15:28 GMT

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:

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

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

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

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

El_BoukfaouiReda — Tue, 20 Jan 2015 15:00:50 GMT

- 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.

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

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

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