1. Oracle 11g R2 64 bit
2. Informatica 9.1.0 64 bit
Successfully. but when I tried import tables from Oracle, I got an error in creating ODBC DSN [ERROR NO:193].
But when I create through ODBC Aministration Tool through control panel, the DSN is sucessfully created. But this can not be used in informatica [It is giving the error 193].
Finally I found that this informatica 9.1 [64 bit] is using 32 bit odbc driver.[By calling c:\\syswow64\odbcad32.exe].
How can we make informatica to use the ODBC 64bit Administration tool [c:\\system32\odbcad32.exe].
Please help me to correct the settings.
Thank you in advance
Edited by: 978351 on Dec 23, 2012 10:42 PM
You're going to have to ask informatica how to do that. The best advice I can give you is to install a 32 bit Oracle client, and use the 32 bit ODBC manager to create the connection. That will get things up and running at least.
Did you get any answer on this? Even i see same issue... I have Win 7 64 bit OS and 64 bit Oracle and 64 bit Informatica. Not able to create ODBC connections because informatica is pointing to 32 bit ODBC.