Qlik Community

QlikView Connector for Salesforce

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

baylor2016
Contributor

Unable to access data in Oracle server

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

Tags (3)
2 Replies
Highlighted

Re: Unable to access data in Oracle server

Hi,

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

And check if this helps

Connectivity to Oracle Database

Regards

ASHFAQ

MVP
MVP

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