Re: Informix and Oracle mixed environment connectivity/coexisting issues

Will Rosales <will.r@ix.netcom.com> wrote: :Currently, I am running Informix Online DSA v7.21 on HPUX10.10 and soon migrating to v7.22 :HPUX10.20. Our applications are developed in PowerBuilder v5 and MicroFocus Cobol v10. :I am looking into installing Oracle for the first time on the same HP server or maybe a separate :server. :1. When Oracle and Informix rdbms are both online, what is the technique/configuration/software :and additional hardware if any needed to connect to both from the same applications running on :NT and Unix? Running on NT I would check out a server based ODBC connection like the one from OpenLink (http://www.openlinksw.com) or possibly SCO (http://www.vision.sco.com). I don't know on Unix. Depends on your application. :2. Is this a simple or complex environment to implement, integrate, and maintain? :3. What troubles or issues are typically encountered? :4. Does Informix or Oracle provide assists for database access in a mixed database environment? :5. Where can I find a good reference guides/sources on this topic? Check out the whitepaper on OpenLinks web page about ODBC drivers. :6. Any added helpful comments are appreciated. :Thanks for your interest and help. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org