Uniface User Forum

 View Only

  • 1.  to access data DB in the network via userver.asn path

    Posted 09-01-2022 11:46
    Dear All
    need your help to access separate data DB server in the network (without the local DB) via userver.asn.
    existing setting when DB server in same userver. ORA1 is data DB and ORA2 is the repository DB.

    [PATH]
    $ORA1    ORA:hqunx1|user|pw
    $ORA2   ORA:hqunx1|user|pw 

    $DEF $ORA1
    $UUU $ORA2
    $IDF $ORA2
    $SYS $ORA2
    $ORA $ORA1

    now i want to direct the data DB(ORA1 setting ) to access  a remote DB server in the network with different IP  ,then urouter , userver and repository will be in one server and data DB is in a different server.  how can i change this settings?
    need your utmost help pl

    Best Regards,
    meththa

    ------------------------------
    Meththa Perera
    IT manager
    Ceylon Electricity Board
    No 50, Chittampalam A. Gardiner Mawatha LK
    ------------------------------


  • 2.  RE: to access data DB in the network via userver.asn path

    PARTNER
    Posted 09-01-2022 12:17

    This help page https://www3.rocketsoftware.com/rocketd3/support/documentation/Uniface/10/uniface/dbmsSupport/dbmsDrivers/Oracle/concepts/ORACLE_LOGON_PATH.htm

    Shows how to configure a tcp connection to a different oracle server, and/or use the SQL*Net setup. 
    Regards, 
    Iain



    ------------------------------
    Iain Sharp
    Head of Technical Services
    Pci Systems Ltd
    Sheffield GB
    ------------------------------

    Original Message


  • 3.  RE: to access data DB in the network via userver.asn path

    Posted 09-02-2022 06:34
    Thanks lain. i'll try it and share the outcome

    ------------------------------
    Meththa Perera
    IT manager
    Ceylon Electricity Board
    No 50, Chittampalam A. Gardiner Mawatha LK
    ------------------------------

    Original Message