Re: Connect to two database engines at same time?

tonytd@ttyrwhit.demon.co.uk (Tony Tyrwhitt-Drake) wrote: >In article <4j6pq7$l1f@jaxnet.jaxnet.com>, chs@jaxnet.com (Children's Home Society Of Florida) says: >> >>Our company currently uses informix-se on a UNIX platform for our >>accounting applications. This same vendor has a DOS based human >>services application written in clipper. They tell me that they are >>currently writing an interface (MS-Windows based using Delphi) which >>will tie the two databases together in order to be able perform some >>cost analysis. >> >>Question is can an application connect to two different database >>engines and open a table from each of the two at the same time. >>Possible configurations: >> 1. informix-se and Dbase >> 2. informix-se and SQL Anywhere (Watcom SQL) >> 3. informix-se and MS SQL Server FWIW: this is very possible. UNIFACE (http://www.compuware.com) has been doing if for ten years with native drivers for each DBMS. You can easily combine data from any supported DBMS (Informix SE/Turbo, Oracle, Sybase, Rdb, DBase, MS SQL server, C-ISAM, Solid SQL, RMS, TurboImage, Ingres, DB2/2, DB2/6000, ...) on one screen. Others are available on a LCD basis with ODBC. There is no native driver for Watcom, so you'll have to drop down to ODBC for that one, however. Or use Solid Server, a good alternative. Jeffrey Mann