Article ID: 240340 - View products that this article applies to.
This article was previously published under Q240340
Attempting to use a query with an Oracle linked server using the MSDAORA OLE DB provider, for example:
may cause an error similar to the following:
Server: Msg 7306, Level 16, State 2, Line 1
Could not open table '"demo"."Product"' from OLE DB provider 'MSDAORA'. The specified table does not exist.
[OLE/DB provider returned message: The specified table does not exist]
[OLE/DB provider returned message: ORA-00942: table or view does not exist]
The query may not work because of case sensitivity in Oracle since SQL Server uses quoted names when it ships queries to a provider.
Use the following rules when referencing tables in an Oracle linked server:
Microsoft SQL Server version 7.0 provides the ability to perform queries against OLE DB providers. This is accomplished by using the OpenQuery or OpenRowset Transact-SQL functions or by using a query with four part names including a linked-server name. For example:
Steps to Reproduce the Behavior
REFERENCESFor additional information on SQL Server distributed queries with Oracle data source, see the SQL 7.0 Books Online topic "OLE DB Provider for Oracle" and the following articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/220915/EN-US/ )PRB: SQL Distributed Query with Oracle Needs Oracle Client
(http://support.microsoft.com/kb/221552/EN-US/ )PRB: SQL Distributed Query with Oracle NUMERIC Column Gives Error
Article ID: 240340 - Last Review: December 5, 2003 - Revision: 4.2