Re: ORACLE,INGRES,SYBASE in a DDBS

|>
|> Does anybody know if it is possible to connect databases made by
|> Ingres, Oracle and Sybase into a distributed system, and how this
|> is done ?

You might look at a product called "OMNI SQL Gateway" from Sybase. This product lets you reference tables from several different database systems, such as Oracle, Ingres, Informix, DB2 and Sybase & Micro Soft SQL Server. All of the tables appear as if they were in the same database and you can perform joins etc. between any of the tables. It does not support two phase commit between all of the databases on update. So its fine for updating one database at a time, but, if you want to update several databases all within one transaction, there is a small amount of risk if there should be a power failure during the distributed update. Its pretty cool because your front end application doesn't know if a table is one database system or another.

-- 
Dave Meldrum    (617) 238 6188 
Sybase Inc.
77 So. Bedford St.
Bulington Ma. 01803