Re: Informix to Oracle connection

Posted in 2006

Summary

svs asked how to connect Informix to Oracle. Art Kagel and VG pointed to IBM's Informix Enterprise Gateway Manager, usable in direct mode or via an Informix server in distributed mode. svs said it did not support Linux. Claus Samuelsen noted the gateway need not run on the database machine and could be set up on a Windows box. DA Morgan questioned the claim that Oracle lacks Linux support.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Platform-Specific Issues

Art S. Kagel — Thu, 19 Jan 2006 13:03:13 -0500 — source: Usenet: comp.databases.informix

svs wrote: > Hi everyone!!! > > > Need help ! > > > I am looking for a way to connect Informix Dynamic Server 2000 Version > 9.21.UC2 on Red Hat Linux release 6.2 to oracle 10g (Linux release > 2.6.9-5.ELsmp). > I found in oracle documentation that there is a way --> Oracle > Transparent > Gateway, but also found that for informix Oracle Transparent Gateway > works > only on solaris and hp ux. is there a gateway or any other software > that works with Linux??? IBM has a similar Gateway product that runs whereever IDS runs and can talk to Oracle servers both local and remote. Contact IBM about the Informix Enterprise Gateway. Art S. Kagel

↪ replying to Art S. Kagel

VG — 19 Jan 2006 10:17:08 -0800 — source: Usenet: comp.databases.informix

The Enterprise gateway manager (http://www-306.ibm.com/software/data/informix/tools/egm/) provides connectivity to non Informix DBs. You can use this in direct mode.. Informix ESQL/C app -> gateway -> Oracle Db or in distributed mode Informix ESQL/C App-> Informix server -> gateway -> Oracle DB. Please check online documentation for further details. VG.

↪ replying to VG

svs — 19 Jan 2006 22:49:33 -0800 — source: Usenet: comp.databases.informix

like oracle it doesn't support Linux :-(

↪ replying to svs

Claus Samuelsen — Fri, 20 Jan 2006 13:33:14 +0100 — source: Usenet: comp.databases.informix

svs wrote: > like oracle it doesn't support Linux :-( > Enterprise Gateway Manager doesn't need to be on the same machine as the database. You could set it up on a windoze box.

↪ replying to svs

DA Morgan — Fri, 20 Jan 2006 08:44:37 -0800 — source: Usenet: comp.databases.informix

svs wrote: > like oracle it doesn't support Linux :-( And since when doesn't Oracle support Linux? -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

Related threads

Glossary

IDS (Informix Dynamic Server)