DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oraOLEDB.Oracle: Provider not found: Oracle 10.1.0.2.0 Client installation

985655Jan 18 2013 — edited Jan 22 2013

Hi All,

I am working on a SSIS task in which i need to get data from Oracle database which is on remote server.

But when created the SSIS package and tried to create the connection from the connection manager using OLE DB connection, I am not able to find the provder 'Oracle Provider for OLE DB' . I have oracle client, toad installed on my machine.Using toad, I am able to connect to the Oracle database.

Please suggest. For time being I am using 'Microsoft OLE DB provider for Oracle' to make the SSIS working.

Edited by: 982652 on Jan 17, 2013 11:02 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2013

Added on Jan 18 2013

#oracle-provider-for-ole-db, #windows-and-net

5 comments

4,341 views