Connection Problems to Oracle Database

Hi,

I have a package connecting to oracle database ,this was developed on 32 bit Windows OS now i moved the same to 64 bit OS and it fails to connect to oracle database.

I have created system DSN and tested it was successfull.

In my package i am using ado.net connection object ,I am using ODBC data provider.I select the Data source in the drop down .provide user name and password and when i hit on test connection it fails with the following message

Test connection failed because of error in initilizing the provider error[08004]

[oracle][odbc][ora]ORA 12154 : TNS could not resolve the connect identifier specified

[Error]IM006[Microsoft][ODBC driver manager] drivers SQL setconnectattr failed

Any help on this will be appreciated

Note:- even though the OS is 64 bit i am using 32 bit ODBC as BI studio can only access 32 bit odbc

32-bit ODBC drivers won't run with 64-bit SSIS. You either need a 64-bit ODBC driver for Oracle (not sure if one exists) or run the 32-bit version of SSIS on the 64-bit box.|||Initially i had installed 64 bit oracle drivers and had created sytem dsn in 64 bit odbc but when i tried accesing the DSN(from drop down in connection object) i created in ado.net connection object i was not able to do so , as using the BI studio you can only access 32 bit odbc for which i had to install 32 bit oracle drivers after creating the dsn in 32 bit odbc i was able to access the DSN but when i did the test connection it failed.with above error message.