Qlik Community

QlikView Connector for Salesforce

Discussion Board for collaboration related to the QlikView Connector for Salesforce.


Unable to access data in Oracle server


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


Tags (3)
2 Replies

Re: Unable to access data in Oracle server


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

And check if this helps

Connectivity to Oracle Database




Re: Unable to access data in Oracle server

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=""];

Community Browser