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)
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)
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)
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)
