Re: Connect to two database engines at same time?

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.