Re: Oracle & Informix connectivity/coexisting issues question

Dave Dargo wrote: > > > >4. Does Informix or Oracle provide assists for database access in a > mixed > > >database environment? > > Each supports their own product and ignores the other one. > > Actually, Oracle provides the Oracle Transparent Gateway for Informix. > This product allows Oracle clients to access both Oracle and Informix > tables as part of a single transaction. This means that a client that > connects to Oracle has access to both the Oracle and Informix tables, > including distributed joins from a single SQL statement and two-phase > commit. You have the capability of updating both databases as part of a > single transaction and having the transaction protected with two-phase > commit. You can visit the gateways section at http://www.oracle.com for > further information. > > Dave Dargo > ddargo@us.oracle.com Informix has the same type of product, called the Enterprise Gateway Manager. It allows you read/write access to Sybase, Oracle, or any UNIX ODBC accessable data source (ie VSAM if you use an ODBC accessable middleware product such as CrossAccess). Allows direct or distributed queries against any or all sources. Very nice. Rob. -- _________________________________ | Robert Donat | | rdonat@sigg.com | | http://sashimi.wwa.com/~donat | |_______________________________|