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 a Technology Solutions Professional for Microsoft's data platform and works out of Microsoft's Houston office. Prior to joining Microsoft, he was a Microsoft SQL Server MVP. He is 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. John is also a Registered Nurse who 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. He volunteers as a nurse at safety net clinics. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Opinions expressed in John's blog are strictly his own and do not represent Microsoft in any way.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement