I am attempting to use a view from a SQL Server database in a data grid on my SP10 site. I set up the External Content Type, created the Data View... The data source reported a "non-specific error" from the server. Went back to my Data Source definition
and noticed something: In the Data Source Properties window, the view's schema is missing. That is, the table shows "Table: .ViewName" instead of "Table: Schema.ViewName".
So I suspect this is the problem. However, how do I fix this? The configuration wizard shows all of the tables in the database, but omits the schema names. There is no apparent way to make sure that the schema names appear.
View Complete Post