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 14 2007 — edited Sep 23 2009

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 Oct 21 2009

Added on Sep 14 2007

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

1 comment

4,065 views