- Microsoft Ole Db Driver Download
- Oracle Ole Db Driver Download
- Microsoft Ole Db Provider
- Microsoft Ole Db Provider For Oracle
64-bit Oracle Data Access Components. Canon bjc 1000sp printer driver free download. This download contains ODP.NET, Managed Driver xcopy only. 64-bit Oracle Provider for OLE DB 12.2.0.1.0. This document describes the Microsoft OLE DB Provider for ODBC, explains the procedures for installing, configuring, and testing the provider, and lists the limitations of the current implementation. Intel(r) hd graphics (core i5).
Active8 years, 4 months ago
As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our new SQL Server 2008 R2 x64 nodes. I have done the recommended system reboot, but OraOLEDB.Oracle does not show in the Linked ServersProviders node in SSMS. The only difference between this installation and previous SQL Server installations is that I am now using SQL Server x64 (on Windows 2008 R2). Should this make any difference?
Note that I am able to connect to Oracle servers using SQL*Plus from the SQL Server nodes directly. The only thing I am missing is that Provider. Anyone know what I am missing? There are many posts around the web, but there seems to be a lot of confusion and outdated links to Oracle's download page.
The ONLY thing I need to be able to do is create a linked server to Oracle, and run select queries against it. I don't need to do anything through Visual Studio.
SomeGuy
SomeGuySomeGuy31711 gold badge33 silver badges1313 bronze badges
2 Answers
After hours of research, I managed to cobble together some working instructions for Oracle 11g R2. As it turns out, you will likely need both the 32 and 64 bit clients installed to have things working in BIDS/Visual Studio/SSMS. I may have installed more Oracle components than I needed, but here's what worked for me:
Microsoft Ole Db Driver Download
- Download 32 and 64-bit clients from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html (click 'see all' to see different versions, otherwise, you'll be downloading the complete Oracle program. Your downloads should be about 600 meg each)
- Run 32-Bit install on the SQL Server. Select 'Custom'
- For Oracle Base, enter 'C:Oracle'
- For 'Software Location', change to C:Oracleproduct11.2.0client_32
- Choose the following components:
- SQL*Plus
- Oracle Call Interface (OCI)
- Oracle Net
- Oracle Services for Microsoft Transaction Server
- Oracle Administration Assistant for Windows
- Oracle Provider for OLE DB
- Oracle Data Provider for .NET
- Oracle Providers for ASP.NET
- Repeat above steps with the 64-bit installer. HOWEVER, change the 'Software Location' to C:Oracleproduct11.2.0client_64
- I got a memory error at this point, but chose to ignore it since I know there is enough
- Ignore the error 'OracleMTSRecoveryService already exists'
Now that the install is done, just need to tweak a few things.
- Make registry changes to HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCMTxOCI
- OracleOciLib should be oci.dll
- OracleSqlLib should be orasql11.dll
- OracleXaLib should be oraclient11.dll
- Make same registry changes to HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftMSDTCMTxOCI
- Create or copy a new tnsnames.ora in C:Oracleproduct11.2.0client_32networkadmin
- Create or copy a new tnsnames.ora in C:Oracleproduct11.2.0client_64networkadmin
- Reboot!
- You should now see OraOLEDB.Oracle as a provider under Linked ServersProviders in SSMS
- Right-click this provider, then Properties, then tick the box for 'Allow Inprocess'
- You can now create linked server through the GUI or T-SQL
Good luck!
SomeGuySomeGuy31711 gold badge33 silver badges1313 bronze badges
Yes, the system architecture makes a lot of difference.
Oracle Ole Db Driver Download
You need to install the x64 Oracle client software for Windows.
Microsoft Ole Db Provider
MassimoMassimo54.2k4545 gold badges173173 silver badges290290 bronze badges
Microsoft Ole Db Provider For Oracle
protected by Community♦May 10 '11 at 14:30
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?