Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Make sure you have same version of client as that of database.
And check if this helps
Connectivity to Oracle Database
Regards
ASHFAQ
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=""];