2 Replies Latest reply: Feb 18, 2013 3:52 PM by 981616 RSS

    Problem in creating ODBC new DSN in Informatica

      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