This discussion is archived
2 Replies Latest reply: Feb 18, 2013 1:52 PM by 981616 RSS

Problem in creating ODBC new DSN in Informatica

981354 Newbie
Currently Being Moderated
I Installed

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points