Skip to Main Content
Forums

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

Comments

Ralph Ashley

Hmmmm,
I pulled base.vessel_registration from the database while I pulled params.vessel table from the model browser.
I still can't get my head around the difference since I just pulled all tables from the DB to a new rel.model.
Seriously, considering moving back to designer, now... :(

Answer

I'll recommend to use DM import functionality or even to switch to standalone version of DM. The picture shows that you are mixing tables from different models or model and directly from database. Your life will be simpler with standalone DM.
Philip

Marked as Answer by Ralph Ashley · Apr 19 2021
1 person found this helpful
Ralph Ashley

Just in case someone else reads this I just want to be clear in that the problem was my importing the tables from different sources, one was directly from the DB while the other was from the list of relational tables.
Solution:
Get the tables from the same source.
I will be installing the stand alone version of DM.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 26 2010
Added on Sep 17 2007
#oracle-provider-for-ole-db, #windows-and-net
4 comments
27,414 views