"INVALID OBJECT NAME" IN UNITABLE

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Steve
Posts: 1
Joined: Fri 29 Apr 2011 22:12

"INVALID OBJECT NAME" IN UNITABLE

Post by Steve » Fri 29 Apr 2011 22:29

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.

????

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 04 May 2011 11:17

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.

Post Reply