Microsoft ODBC-OLE DB providers for Oracle

Question

Hi, I need to know if it exists any Microsoft ODBC-OLE DB providers for Oracle in order to read from Oracle to write to SQL Server 2008 R2 or later.

Many thanks

Answer 1

Here are a couple of links.  (Note that I do not have access to Oracle in order to test anything here.)

http://support.microsoft.com/kb/244661

http://msdn.microsoft.com/en-us/library/ms254502.aspx

http://www.connectionstrings.com/oracle

RLF

Answer 2

Hi Russell, thanks for your reply. Do you know where can I download the Microsoft ODBC and OLE DB providers for Oracle?

Thanks

Answer 3

Do you know where can I download the Microsoft ODBC and OLE DB providers for Oracle?

 

These drivers/providers used to be distributed as part of MDAC in older operating systems but are no longer included in newer Windows OS versions.  You should use components provided by Oracle.   See http://msdn.microsoft.com/en-us/library/ms810810.aspx. 

Both the needed Oracle provider and connectivity components are available on the Oracle client installation media.

 

---

Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/