Re: Connect to two database engines at same time?

Norwood Story wrote: > > chs@jaxnet.com (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. > > > > > >Mark Barrentine > >Information Systems Manager > > > Yes, it is possible to have an application connect to more than one > vendor's database at the same time. > > Powerbuilder has this capability built into it with the data pipeline. I > haven't tried it with embedded SQL in a C program, but would bet that it > is possible. Norwood, et al, Delphi uses the Borland Database Engine (BDE) technology to allow heterogenous joins within a single application. Anyone using Delphi or more specifically the BDE can accomplish this feat. Delphi Client/Server includes the BDE and Native SQL drivers for Informix, Borland InterBase, Oracle, Sybase, MS-SQL, and recently released DB2 drivers. It also supports ODBC. Hope this helps, Mike Destein Systems Engineer Borland International Washington DC Office