I had the same problem Sql Server R2 64x connecting to an Oracle 8 , and solved it following your instructions. This worked very well for me and I was able to skip several steps. Last step was specifying a login. Once done, the provider should be available to use in the linked server definition. You can’t post JavaScript.

Uploader: Gokazahn
Date Added: 12 June 2009
File Size: 60.63 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 90021
Price: Free* [*Free Regsitration Required]

Pls suggest how to check if my oracle drivers are corrupted?

At the time of writing: But still issue is not resolved. March 10, at 2: June 7, at 7: You can’t post new topics. Unthreaded, ascending Unthreaded, descending.

Oracle client and networking components were not found. December 20, at Cognos Controller Controller Software version: We configured the linked server for ‘rpc out’ so we can send a simple passthrough query to test connectivity: On a Win 8.


Checked and insgall again and again, but still the same. Document information More support for: Provider cannot be found. Should I add an answer to this question or ask a new question?

oracle – What do I need to install to use OraOLEDB – Stack Overflow

November 17, at How to use the tnsnames. January 8, at 1: Scenario 1 – The Controller application server does not have the Oracle client s installed.

If the user tries to launch Controller, a similar error appears. September 5, at 7: You can’t edit your own topics. It contains the features and innstall that illustrate how to use this product to solve real-world problems.

You can’t post new polls. You can post emoticons.

Oracle Provider not registered on the Local machine

February 2, at 1: No idea why the detailed definition was needed …. M Schenkel 3, 10 47 You can’t delete your own events. June 20, at 8: By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.


Connections to this server version are no longer supported.

Creating a Linked Server for Oracle in 64bit SQL Server

You can read topics. The exact error will depend on the environment, for example: NET Repeat above steps with the bit installer. I don’t want to install the entire Jnstall Client just to acquire the 1 driver I need to accomplish my task.

Author: admin