Skip to main content

Uniface 8: Uniface router question

  • November 19, 2018
  • 4 replies
  • 0 views
Jan Cees Boogaard

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?

4 replies

Jan Cees Boogaard

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?

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)
Jan Cees Boogaard

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?

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)
Jan Cees Boogaard

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?

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)
Jan Cees Boogaard

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?

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:

[DRIVER_SETTINGS]
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.

 

Greets

Thomas


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

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement