Unable to view data for  SQL Server Views

Discussion created by e_saurabh on Jul 3, 2012
   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 & SQL Server 2008.

Thanks in advance. Any help will be apprecitated.