Here are a couple of links. (Note that I do not have access to Oracle in order to test anything here.)
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