Re: Connect to two database engines at same time?

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. Using ODBC drivers, talking to more than one database of different types is possible. Some tools would also require that you have INET/ISTAR running . > >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. Once set up (the hard bit ) it should not take much maintaining unless you change the database structure. I am about to try using ODBC to Informix Online, VMark's Universe and Access on a network already running Inet/Istar, although I cannot recall how I got talked into doing this. I would be interested if anyone else has tried similar.