Re: Multiple databases query? NEED HELP

You could use OpenLink's Virtuoso to connect to multiple databases. Please visit http://www.openlinksw.com to download. General Information:

Virtuoso is a revolutionary, next generation, high-performance virtual database engine for the Distributed Computing Age. It is a core universal data access technology set to accelerate our advances into the emerging Information Age.

Virtuoso provides transparent access to your existing data sources, which are typically databases from different database vendors.

Through a single connection, Virtuoso will simultaneously connect your ODBC, JDBC, UDBC, OLE-DB client applications and services to data within Oracle, Microsoft SQL Server, DB/2, Informix, Progress, CA-Ingres and other ODBC compliant database engines. All your databases are treated as single logical unit.

The full installation takes up less than 10MB of disk space. The actual database element takes up less than 5MB.

Virtuoso currently supports Linux ("glibc2" and "libc5" based distributions), Windows 95/98/NT/2000, and UNIX (all flavors). There are plans to port Virtuoso to the OS390, OS400, VMS, and MacOS platforms subject to demand.

--
Thanks,

Edward A. Geddis
Technical Support Consultant
OpenLink Software
http://www.openlinksw.com
Making Technology Work for You

Phillip H <hzl_at_optusnet.com.au> wrote in message news:7m7p3l$noo$1_at_news1.mpx.com.au...
> Hi All,
>
> I am doing a thesis that query against at least two databases. These
> databases are heterogeneous. It may include Oracle, Microsoft Access,
> Microsoft SQL and DB2. A single query will involve at least two tables
that
> can be in same or different databases.
>
> For example, Payroll data is stored in an Oracle DB, while staff task data
> is in an Access DB. Now I want to retrieve all staff's current salary and
> current task list by a single SELECT statement (syntax may vary):
>
> SELECT name, salary, task
> FROM current_salary cs, current_tasks ct
> WHERE cs.name = ct.name;
>
> The purpose is to hide the details of data distribution. I implement it
with
> Developer 2000. Any ideas on how to do it are appropriated. Are there any
> books or web sites helpful?
>
> Thanks in advanced.
>
> Phillip
>
>
Received on Thu Jul 15 1999 - 13:18:06 CDT