Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 05, 2016 at 03:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2016 at 06:59 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2017 at 10:31 AM

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

    Add comment
    10|10000 characters needed characters exceeded