Page 1 of 1

"INVALID OBJECT NAME" IN UNITABLE

Posted: Fri 29 Apr 2011 22:29
by Steve
SQL SERVER 2008 ENTERPRISE
PROVIDER = SQLServerUniProvider
CONNECTION = UniConnection
ACTIVE CONNECTION TO ADVENTUREWORKS database
TABLE COMPONENT = UniTable

ERROR "INVALID OBJECT NAME" WHEN I SELECT ANY OF THE TABLE NAMES AND TRY TO OPEN TABLE.

????

Posted: Wed 04 May 2011 11:17
by Dimon
To solve the problem, you should set the TableName property to the "SchemaName.TableName" value but not to "TableName" if not default schema ("dbo") is used.
We will change this behaviour in design time editor so that schema name was displayed. This change will be included in the next SDAC build.