Created On: 10 October 2010
Problem:
Issuing a query in the MSSQL Query Analyzer in the form:
select * from [linkedserver]..[owner].
select * from [linkedserver]..[owner].
Resolution:
The information in the AcuXDBC system catalog is stored in upper case. This makes no difference with the openquery but the fully-qualified format is sensitive to this.
The resolution is to use uppercase for the owner and table names:
select * from [linkedserver]..[OWNER].
The resolution is to use uppercase for the owner and table names:
select * from [linkedserver]..[OWNER].