Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

3 Replies
Anonymous
Not applicable
Author

Try this in the TNS Service Name:

//ip.ad.dr.es:1521/SID

Regards,

Dinesh.

Not applicable
Author

DBCHi Dinesh:

You answered five minutes after I posted this question. Wow!

Using anything other than "XE" in the TNS Service Name in the ODBC Data Source Administrator causes the connection test to fail. I suspect that there might be something wrong in my ODBC Oracle driver installation. Will reinstall. And will try a 64-bit ODBC driver.

In the meantime I downloaded installed a MySql ODBC driver. With this I was able to connect instantly from QlikView to the MySql database. This gives me what I need to begin exploring QlikView.

Thanks

Murray

Not applicable
Author

Hi,

i have the same proble with a QV 11

do you find a solution for this problem.