Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this in the TNS Service Name:
//ip.ad.dr.es:1521/SID
Regards,
Dinesh.
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
Hi,
i have the same proble with a QV 11
do you find a solution for this problem.