RE: Non-Informix databases

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET

Hannes Visagie — Tue, 6 Jun 2000 21:33:11 +0200 — source: Informix-list mailing list archive (1991-1998)

As far as I know, Openlink have a middleware product "VIRTUOSO" that can query data from different databases in one statement. Never used it. www.openlinksw.com -----Original Message----- From: Watawinona [SMTP:watawinona@aol.com] Sent: Tuesday, June 06, 2000 10:16 PM To: informix-list@iiug.org Subject: Re: Non-Informix databases > >Any way to access an Informix database and a non-Informix database (dare I >say it?) in the same query? > yes. Use a supported gateway. Use ODBC, or better JDBC. Alternatively an X-Open server. Nona Nona

↪ replying to Hannes Visagie

andrewhill@my-deja.com — Mon, 12 Jun 2000 14:52:10 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, Yes, indeed you can use Virtuoso http://www.openlinksw.com/virtuoso to perform one query that joins across heterogenous back end datasources. Best regards, Andrew Hill Openlink Technical Support In article <8hkuir$oqs$1@news.xmission.com>, Hannes Visagie <hvisagie@mibco.org.za> wrote: > > As far as I know, Openlink have a middleware product "VIRTUOSO" that can > query data from different databases in one statement. Never used it. > www.openlinksw.com > > -----Original Message----- > From: Watawinona [SMTP:watawinona@aol.com] > Sent: Tuesday, June 06, 2000 10:16 PM > To: informix-list@iiug.org > Subject: Re: Non-Informix databases > > > > >Any way to access an Informix database and a non-Informix database (dare I > >say it?) in the same query? > > > > yes. Use a supported gateway. Use ODBC, or better JDBC. Alternatively an > X-Open server. > > Nona > Nona > > Sent via Deja.com http://www.deja.com/ Before you buy.