Article ID: 220915 - View products that this article applies to.
This article was previously published under Q220915
When you try to use a SQL 7.0 linked server by using the Microsoft OLE DB Provider for Oracle, you may receive the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installation.
You will be unable to use this provider until these components have been installed.]
The error occurs because the Oracle client and networking components are not installed. The computer that is running SQL 7.0 requires the Oracle client and networking components to use MS Oracle provider to connect to an Oracle server.
If you are on a SQL Server cluster, you must install Oracle client and networking components on each of the nodes (or computers) that are part of the cluster. The Oracle client software (SQL*Net) is manufactured by Oracle Corporation. This software can be obtained only from Oracle Corporation.
With Microsoft SQL Server 7.0, you can perform queries against OLE DB providers. You do this 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:
SQL Server 7.0 installs Microsoft OLE DB Provider for Oracle. To query a local or remote Oracle server database from SQL Server query that uses the Microsoft OLE DB Provider for Oracle, you must install Oracle client and networking components on the computer that is running SQL Server.
sp_addlinkedserver 'mylinkedserver', 'product_name', 'myoledbprovider', 'data_source','location', 'provider_string', 'catalog' SELECT * FROM OPENQUERY(mylinkedserver, 'select * from table1')
For Transact-SQL code examples on setting up and using distributed queries with an Oracle server search on "Microsoft OLE DB Provider for Oracle" in the index of the SQL Server 7.0 Books Online.
For more information about hardware and software vendor contact information, visit the following Microsoft Web site:
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Article ID: 220915 - Last Review: May 13, 2004 - Revision: 5.3