How to do a query across 2 databases?

ammar_agano...@my-deja.com

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

How to do a query across 2 databases?

I have a DBISAM database on one side, and a Winzeos (MySQL) database on
the other, and I need to do a cross query (i.e. select all records from
Winzeos that are not in DBISAM). Is there any way to acomplish that?
Any improvisation?
regards,
Ammar

Sent via Deja.com http://www.deja.com/
Before you buy.

M.H. Avegaar

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How to do a query across 2 databases?

Look in the Delphi help for 'heterogeneous join'...

<ammar_agano...@my-deja.com> schreef in bericht
news:8incr9$tk5$1@nnrp1.deja.com...

Quote

> I have a DBISAM database on one side, and a Winzeos (MySQL) database on
> the other, and I need to do a cross query (i.e. select all records from
> Winzeos that are not in DBISAM). Is there any way to acomplish that?
> Any improvisation?
> regards,
> Ammar

> Sent via Deja.com http://www.deja.com/
> Before you buy.

PINK

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How to do a query across 2 databases?

Quote

M.H. Avegaart <avega...@NOSPAMmccomm.nl> wrote in message

news:8infpk$cbr$1@porthos.nl.uu.net...

Quote

> Look in the Delphi help for 'heterogeneous join'...

Probably not so simple, DBISAM uses its own version of TQuery and of
TDataBase. Might (I say might, never had to do this before) have to do the
DBISAM query, and save the result set to some type of dataset that can be
queried with a standard TQuery.

Quote

> <ammar_agano...@my-deja.com> schreef in bericht
> news:8incr9$tk5$1@nnrp1.deja.com...
> > I have a DBISAM database on one side, and a Winzeos (MySQL) database on
> > the other, and I need to do a cross query (i.e. select all records from
> > Winzeos that are not in DBISAM). Is there any way to acomplish that?
> > Any improvisation?
> > regards,
> > Ammar

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Other Threads

1. Query across two databases

2. ADO & query across multiple databases

3. QUERY ACROSS TWO DATABASES

4. Query across two databases

5. Heterogeneous Query across two databases

6. Query across 2 SQL 7 Servers?

7. Query problems across multiple DB Servers

8. Query problems across multiple DB Servers

9. Query across multiple DB Servers

10. Database connection across DLL's