Re: How to Mimic Access' Externally Linked Tables using ADO?

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 01/22/05 

Date: Fri, 21 Jan 2005 18:22:30 -0800

ADO does not have a query engine. It's an interface to query engines. It's
the query engine that does all the database IO, linking and joining. What
DBMS are you accessing? Many have similar "linked" table features. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Shawn B" <ext.news.1@bdenim.ca> wrote in message 
news:41f1765a$1@obsidian.gov.bc.ca...
> Hi All,
>
> I would like to simulate/mimic the behaviour of Microsoft Access' 
> "Externally Linked Tables" from within ADO so that I can, in effect, 
> perform a single query based on tables from multiple 
> databases/connections.  Is this possible?  If so, how?
>
> Thanks in Advance,
>
> Shawn.
>

Relevant Pages

  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... could transfer, as Access does, in a query through ADO, things would go much ... inelegant if there is a corresponding means within ADO. ... > It's the query engine that does all the database IO, ... >> Shawn. ...
    (microsoft.public.data.ado)
  • Re: dbGonazles database for Delphi, Kylix and C++Builder
    ... If I understood your Database description right, ... In your PDF file ... > dbGonzales is a high speed object oriented client/server database. ... > - a SQL query engine will be available in the final version. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... William (Bill) Vaughn ... > we could transfer, as Access does, in a query through ADO, things would go ... >> It's the query engine that does all the database IO, ... >> Microsoft MVP ...
    (microsoft.public.data.ado)