SSIS: ODBC Connection Issue in BIDS 2008

I have an oracle DB i need to talk to so i installed the drivers and added it to the system DSN Data Sources. IM ON SQL SERVER 2008 R2 64bit

In BIDS, I can see the name of the DataSource, however when i go to enter it in the connection manager I get the following error:

TITLE: Connection Manager

Test connection faile开发者_运维问答d because of an error in initializing provider. ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Any Ideas on how to resolve this?

I can connect to the Oracle DB through SQL Plus so i know i have connectivity.

Thanks!

When you installed the 11g client, I assume you did a custom install and installed the ODBC driver, right? And you set your ODBC DSN up using the Oracle Driver, not the Microsoft Driver? Did you test the DSN with the ODBC wizard?

@kevin

The Test connection failed because of an error in initializing provider. ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

this error can be resolved by using a 32 bit driver for oracle connectivity and setting the package runtime properties to set 64 bit runtime= false.

also create a odbc dsn by using the 32 bit oracle driver.on 64 bit machines search for odbc32.exe. the path for it is the following C:\Windows\SysWOW64\odbcad32.exe. run this as an administrator and use this DSN in your SSIS package and the issue will be resolved.