Should this make any difference? Once done, the provider should be available to use in the linked server definition. The ODAC only seems to go up to 10g. You can’t delete your own topics. Thank you for your interest in this question.

Uploader: Zulugrel
Date Added: 22 November 2010
File Size: 18.47 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 48322
Price: Free* [*Free Regsitration Required]

How to install Oracle OLE drivers for use in SQL Server R2 x64 – Server Fault

I am little bit confuse over it. Yes, the system architecture makes a lot of difference. May 16, at 3: Your help would be greatly appreciated — Like you said, there were lots of postings on this, but most are out-of-date.

How to use the tnsnames. Let us know if this helps.

You can’t edit HTML code. Earlier the oracle DB which I was connecting was 11g at that time there was no issues. Server Fault works best with JavaScript enabled. Oracle’N’DynamicParameters’1 Then create the linked server definition.


I will run the client installation and install only the component piece you have referenced. Download 32 and bit clients from http: SomeGuy 1 3 Provider cannot be found.

These interfaces are available from various database providers.

You must register online before using Oracle MetaLink. I had the same problem Sql Server R2 64x connecting to an Oracle 8and solved it following your instructions. You can’t post new topics. Administrator clicks on database connection, and clicks ‘test’. Yes, Reconfiguring would be the best idea to do, Make sure you test once server is rebooted after changes, else change wont get impacted.

Introduction to Oracle Provider for OLE DB

I don’t need to do anything through Visual Studio. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.

I’ll try the full client for now, but I’ve never had to do that before. This was fine for Windows Server After hours of research, I managed to cobble together some working instructions for Oracle 11g R2. An exception occurred while executing a Transact-SQL insttall or batch. I had to do it as an admin.


You can’t post new polls. Then create the linked server definition.

Creating a Linked Server for Oracle in 64bit SQL Server

Does anyone know where I can get the driver or where I can get explicit instructions for installing the driver on SQL Server??? You can download attachments.

M Schenkel 3, 10 47 June 20, at 8: A provider may implement optional COM interfaces to provide additional functionality. Hello, This worked for me on MSSQLand I’ve tried before onso the problem I was getting was the Oracle driver is missing, but in it’s the driver is available.

You may need to reboot computer for change to take effect.