From: BManry@us.oracle.com (Bill Manry) Subject: Re: [Q] Handle Informix + Oracle DB from same C++-program? Date: 1996/04/04 Message-ID: <4jvmj5$o4s@inet-nntp-gw-1.us.oracle.com>#1/1 references: <3162952F.72B1@sectra.se> organization: Oracle Corp. USA reply-to: BManry@us.oracle.com newsgroups: comp.databases.oracle,comp.databases.informix Almut Herzog wrote: >I am investigating the possibility to have *one* C(++)-program that can >insert, update, select... in both an Informix and Oracle database. >I wonder if this is possible at all as both vendors make use of the >sqlca structure. The program would have to pass through Pro*C++ as well >as ESQLC (this does not sound feasible, does it?). >I do not *have* to be able to join between Informix and Oracle tables, >but maybe in a year or so I want that, too. >Would ODBC help here? Remember, I need a C(++)-program. Which products >can be of use (except Oracle-Gateways-to-Informix which is far too >expensive)? You might be able to do this by coding separate Pro*C/ESQLC source programs (subroutines) for each database or perhaps a single program using ODBC. If you need to update both databases in a single transaction, though, you risk integrity problems due to the absence of coordinated commit/rollback/recovery. It is possible to solve that by running the application in an environment that has its own recovery coordination (e.g. a TP monitor). That could be more expensive than buying our gateway, which provides recovery coordination as well as the join capability you may need in the future. I don't see any way you'll get that with ODBC. /b -- Bill Manry - Mainframe & Integration Technologies - Oracle Corp. USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation.