[INFORMATICA] - The specified DSN contains an architecture mismatch between the Driver and Application.

I am trying to connect to oracle using power center designer 9.5.1 > Import Database source option and I get this error "The specified DSN contains an architecture mismatch between the Driver and Application.

" .

Windows 7 OS 64 bit

Oracle 11 G Release 2 64 bit

Informatica Server 9.51 64 bit

Informatica Client 9.5.1 32 bit [because there is no 64 bit exe for client]

I tried to run

c:\windows\syswow64\odbcad32.exe and I didn''t see an oracle entry to create user or system dsn so installed ODAC 32 bit fromhttp://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html then I see an oracle entry in here as well now BUT when I try to connect test connection to oracle it fails. See second snapshot. May be because it i 32 bit driver trying to connect oracle 64 bit database doesn't work.

I tried to run

c:\windows\system32\odbcad32.exe , I see an oracle entry to create user or system dsn. Test connection to oracle works fine. From Start>Programs> ODBC is using the exe from this location on 64 bit windows OS

To Resolve this issue You can use : Data Direct 6.0 Oralce Wire Protocal Driver in informatica

   

click on Test connection--->OK---> APPLY