Wednesday, June 29, 2011

SharePoint 2010 External Content Type

External Content Types Error Message
Using SharePoint Designer 2010, whiling trying to create a new External Content Types, I got the following error message while trying to expand the Tables/Views under the database:

"Can't complete refresh"
"Skipping the following table because it is not configured for use"
"Line 1: Incorrect syntax near '('".

The Routines folder expands fine.

It seems this error is due to the "unofficial" compatibility issue between SQL 2000 server and SharPoint 2010.

No comments:

Post a Comment