Re: Connect to two database engines at same time?

Children's Home Society Of Florida wrote: > > 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 > > If possible, any ideas on how difficult this will be to set up and > maintain or other caveats. The Borland Database Engine (used in our Visual dBASE, Paradox, Delphi and now C++ products) was designed to do that sort of thing easily. Your vendor is not pulling your leg. -Dan Veditz