Unable to access data in Oracle server

[baylor2016]

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

[ashfaq_haseeb]

Hi,

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

And check if this helps

Connectivity to Oracle Database

Regards

ASHFAQ

[maxgro]

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