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. Is it a restriction of Arc Catalog for not to able to see the View or there's 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.0 & SQL Server 2008 R2.
Thanks in advance. Any help will be apprecitated.