Uniface router question

Author: dave.manchester@nucor.com (dmanchester)

Our current environment is Uniface 8 and we exchange data with several legacy systems that are on oracle 7, 8, & 10 databases. A new system is to be installed later this year that resides on an oracle 11 database. Here is our dilemma. We cannot upgrade our Uniface application to version 9 to get connectivity to oracle 11, because U9 does not support oracle 7 & 8.  And Uniface 8 does not support oracle 11.

I was thinking that maybe we could install a Uniface 9 compatible router to connect to the oracle 11 database and somehow connect our Uniface 8 router to the Uniface 9 router.
Is something like this even possible?


  1. Hi Dave,

    an option may be to use some SQL*Net in between to access the Ora11 just as Ora10 (or so).

    Once upon a time, we used this way of handling different Oracle Versions

    Author: ulrich-merkel (ulrichmerkel@web.de)
  2. I am not a specialist. My feeling is that Oracle 7 to 11 probably is too big a span for 1 SQL*Net version (or whatever they call it today). You could talk to and Oracle specialist to see if there is a backend solution possible where the Oracle 7/8/9 tables are "published" in an Oracle 10 database and Uniface only talks to that database.

    Author: Theo Neeskens (tneeskens@itblockz.nl)
  3. Hi Theo,

    think there is some misunderstanding:

    the SQL*Net is only to give an Ora11 database a Ora10 interface for Uniface8,
    all the other Oracle Versions will be handled as beforel.

    Author: ulrich-merkel (ulrichmerkel@web.de)
  4. I suggest using Oracle 10.2 client to access Orace 11. I think accessing an Oracle 11 database is only supported by Oracle from 10.2 client. You may use these settings in your ASN file:

    ORA                 U6.2
    USYS$ORA_PARAMS     u4_compatibility, dac, dpc, dri, dpa, use_timestamp

    The important ones coming from Oracle 8 and before are u4_compatibility and perhaps use_timestamp to support the TIMESTAMP format in uniface.




    Author: Marvel (thomas.hucke@spb.de)