Re: Connecting Informix / Oracle for data movement -- repost

Posted in 1998

W. H. SMITH — Wed, 04 Feb 1998 10:58:59 -0500 — source: Informix-list mailing list archive (1991-1998)

Peries, Chaminda wrote: > > Use ODBC ! You can access Oracle, Informix or almost any other > database using ODBC. > You might want to have a layer of software that would filter the data, > determine which database it needs to be written to, make odbc calls to > the respective database. You can use any tool that supports odbc - C, > C++, Delphi, Powerbuilder, VB, C++ Builder etc. > > If you want to write something to Oracle after event on the Informix > system then try using a trigger to invoke the odbc program.( I am not > sure if this would work) > > Chaminda Peries > > We're looking for a 'server-to-server' connection between HP boxes, possibly using ESQL/C, 4GL, or Pro*C to move the data. True client-server programming isn't possible at this time. Any way to do what you suggested within those constraints?? John Carlson Informix DBA WH Smith, Inc.