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!

Connection issues between 64 bit SSIS and Oracle in 64bit

445547Sep 17 2007 — edited Aug 29 2010

I've got a Win2K3 Std Ed server (x64) running 64-bit SQL Server 2005 Enterprise Edition. I've installed the Oracle 10g 64 bit and and installed ODAC 64 bit then oracle patch to take care of () issue, i managed to create a link server on management studio and connect to oracle a 64 bit server

Now... when I try to create a new connection manager in SQL Server 2005 Integration Services i got the following error, the OLEDB provider for Oracle can't be found, and when I try to manually add an underlying OLEDB connection to the database, SQL Server reports: i got the following error....
Test connection failed because of an error in initializing provider. The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.

Note: my sql server agent is not running on this server, let me know if this is an issue

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 26 2010

Added on Sep 17 2007

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

4 comments

27,578 views