Skip to Content
0

Want to set up the new tnsnames.ora path for a PB application

Dec 05, 2016 at 04:34 AM

86

avatar image

I have 2 Powerbuilder applications in my machine and both using oracle 11g client. Now I have installed oracle 12c client so that the 2nd application can work with oracle 12c and the first one to continue working with oracle 11g. Before the oracle 12c installation there was only one tnsnames.ora file in the Oralce 11g folder. Now i have placed the new tnsnames.ora file in my 12c oracle installation folder but my 2nd powerbuilder applciation still refers the old one. Kindly help me on how to make my 2nd applciation to point to the 12c tnsmanes.ora file. I'm unable to find where the tnsnames.ora file path is set in my pb application.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Harish Karra Dec 05, 2016 at 03:41 PM
0

Hi Sudha,

First - Check PB start up commands and startup profiles, if client path is hardcoded there then you need to change it to different client path.

If it is taking the client path from user profile then you can not use different client paths for 2 different PBs until unless you hardcode it in your PowerBuilder startup procedure.

Regards,

Harish Karra

Share
10 |10000 characters needed characters left characters exceeded
Sudha R Dec 08, 2016 at 06:59 AM
0

Hi ,

Now I'm able to connect the 12C client DB from PB DB profile. But the PB script fails to read from the 12C DB. But when I ran the same query in ISQL under DB painter in PB, I am able to get the results.

Do you think whether it is any driver problem or anything else?

I'm using only SQLCA as the transaction object.

Share
10 |10000 characters needed characters left characters exceeded
Sudha R Feb 16, 2017 at 10:31 AM
0

Thanks. Its been resolved and it was a firewall issues.

Share
10 |10000 characters needed characters left characters exceeded