Friday, January 13, 2012 5:23 PM
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.
Friday, January 13, 2012 6:49 PM
Here are a couple of links. (Note that I do not have access to Oracle in order to test anything here.)
Saturday, January 14, 2012 7:12 AM
Hi Russell, thanks for your reply. Do you know where can I download the Microsoft ODBC and OLE DB providers for Oracle?
Saturday, January 14, 2012 2:56 PMModerator
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/
- Proposed As Answer by amber zhangModerator Friday, January 20, 2012 4:54 AM