topic Unable to access data in Oracle server in QlikView

Unable to access data in Oracle server

baylor2016 — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

I installed Oracle client and was able to connect to Oracle server since the test connection succeeded. However, the connection string was not copied to the script and I was not be able to use Select.... When I click the Select... button, nothing happened.

Please advise. Thanks

Longmatch

Re: Unable to access data in Oracle server

ashfaq_haseeb — Sun, 08 Feb 2015 06:10:57 GMT

Hi,

Make sure you have same version of client as that of database.

And check if this helps

Connectivity to Oracle Database

Regards

ASHFAQ

Re: Unable to access data in Oracle server

maxgro — Sun, 08 Feb 2015 09:11:34 GMT

Sometimes it happens

when it happens, I try again, or I copy and modify a working connection to oracle taken by another .qvw

These are some example (I use tnsnames; change connect32 to connect for 64 bit oracle client, change zzzzz, change user and password)

ODBC CONNECT32 TO zzzzz (UserId is xxxxx, Password is yyyyy);

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Password=yyyyy;Persist Security Info=True;User ID=xxxxx;Data Source=zzzzz;Extended Properties=""];