DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in creating ODBC new DSN in Informatica

981354Dec 22 2012 — edited Feb 18 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2013

Added on Dec 22 2012

#odbc, #windows-and-net

2 comments

2,442 views