THE SQL Server Blog Spot on the Web

Welcome to - 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:


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


Click Next and ignore the warning you’ll see.


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.


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.


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



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?



October 6, 2011 12:10 PM
Anonymous comments are disabled

About John Paul Cook

John Paul Cook is a database and Azure specialist in Houston. He previously worked as a Data Platform Solution Architect in Microsoft's Houston office. Prior to joining Microsoft, he was a SQL Server MVP. He is experienced in 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 recently completed the education to become a psychiatric nurse practitioner. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Connect on LinkedIn

This Blog



Privacy Statement