topic Unable to view data for SQL Server Views in Data Management Questions https://community.esri.com/t5/data-management-questions/unable-to-view-data-for-sql-server-views/m-p/571737#M32405 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>&nbsp;&nbsp; I have a SQL Server View in SQL Server 2008. The view is created and the results can be retrieved in the SQL Server. Now when I am going to connect SQL Server through OLEDB Connection in Arc Catalog I am not able to see the data associated with the view. When I export it to a .dbf file, it does show me the data. But selecting the view alone doesnt bring out any data for me. Is it a restriction of Arc Catalog for not to able to see the View or theres some other option to view it. I am using the same credential information as when I use SQL Server to create View and connect to the Arc Catalog and go thru the OLEDB SQl Server connection. Using ArcGIS 10 &amp; SQL Server 2008.</SPAN><BR /><BR /><SPAN>Thanks in advance. Any help will be apprecitated.</SPAN><BR /><BR /><SPAN>~Saurabh.</SPAN></BODY></HTML> Tue, 03 Jul 2012 11:13:04 GMT SaurabhDasgupta 2012-07-03T11:13:04Z Unable to view data for SQL Server Views https://community.esri.com/t5/data-management-questions/unable-to-view-data-for-sql-server-views/m-p/571737#M32405 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>&nbsp;&nbsp; I have a SQL Server View in SQL Server 2008. The view is created and the results can be retrieved in the SQL Server. Now when I am going to connect SQL Server through OLEDB Connection in Arc Catalog I am not able to see the data associated with the view. When I export it to a .dbf file, it does show me the data. But selecting the view alone doesnt bring out any data for me. Is it a restriction of Arc Catalog for not to able to see the View or theres some other option to view it. I am using the same credential information as when I use SQL Server to create View and connect to the Arc Catalog and go thru the OLEDB SQl Server connection. Using ArcGIS 10 &amp; SQL Server 2008.</SPAN><BR /><BR /><SPAN>Thanks in advance. Any help will be apprecitated.</SPAN><BR /><BR /><SPAN>~Saurabh.</SPAN></BODY></HTML> Tue, 03 Jul 2012 11:13:04 GMT https://community.esri.com/t5/data-management-questions/unable-to-view-data-for-sql-server-views/m-p/571737#M32405 SaurabhDasgupta 2012-07-03T11:13:04Z