3 Replies Latest reply: Sep 7, 2012 1:54 PM by Belgacem Ejmal RSS

    Oracle Express 10g - odbc fails in QlikView10

      I cannot get QlikView to connect to my local Oracle Express 10g database.

      The DSN texts OK in the ODBC Data Source Administrator (accessed with SysWOW64\odbcad.exe. However in QlikView10 when I try the same DSN it fails the "Test Connection" with

      "SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora-12145: TNS:could not resove the connect identifier specified".

      I enabled the "Force 32 Bit" check box.

      What else I should try?

      Murray