THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Oracle Linked Servers on Windows Server 2008 R2

Oracle hasn’t yet released versions of its client software for Windows Server 2008 R2. If you need to create an Oracle linked server, that’s a problem. You’ll see this installation block when attempting to install the Oracle client software for Windows Server 2008:

image

It’s very simple to fix. Check the first checkbox to make the installer ignore the version check.

image

Click Next and ignore the warning you’ll see.

image

The installation should complete successfully.

Windows does offer various strategies for mitigating application compatibility problems. There is one called a version lie shim which sometimes is successful in resolving such installation blocks. It requires right-clicking the installer executable and making the OS to be an earlier version number. This approach was not successful in installing the Oracle client software.

image

When you’re done installing the Oracle client software, if you’re going to create a linked server, be sure to make the Oracle provider inprocess.

image

Published Monday, March 15, 2010 1:05 PM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Don said:

I wasted two days on this problem searching around and trying different versions of Oracle.  I never would have thought that the linked server would have worked if the Oracle installation didn't pass the OS requirement check.

Thank you!

May 18, 2011 11:38 AM
 

Al said:

I need to connect from SQL Server 2008 R2 to Oracle 9i. I will install a 10g client and the ODAC for 10g because I don't think I should go all the way back to 9i just because they still have it here. I am hoping that I will be able to connect. Do you have any suggestions on this one?

Thanks

Al  

October 6, 2011 12:10 PM

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is both a Registered Nurse and a Microsoft SQL Server MVP experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. Experienced in systems integration and workflow analysis, John is passionate about combining his IT experience with his nursing background to solve difficult problems in healthcare. He sees opportunities in using business intelligence and Big Data to satisfy healthcare meaningful use requirements and improve patient outcomes. John graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement