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

From: Shawn B (ext.news.1_at_bdenim.ca)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 01:19:15 GMT

Thanks for the reply Bill,

My problem is that I have an application that requires access to a number of
different DBMS's. The type and structure of the data coming is not
necessarily known ahead of time depending on the source of the data -
sometimes it is Oracle, DB2, Text, Excel and who knows what. The nice thing
about ADO, is that it provides a nice means to get at various kinds of data
in a relatively uniform way.

The application I need to modify, as is often the case, started out as
something small and morphed into this fancy-dandy utility as new
requirements arose. However the problem now is that some of the data we are
receiving is large and the application transfers data row by row. If we
could transfer, as Access does, in a query through ADO, things would go much
quicker.

I know we can cobble this up using an MS Access "wrapper" around the data
and linking to the source and destination DBMSs, but this strikes me as
inelegant if there is a corresponding means within ADO. By your response, I
imagine I am destined to go my "inelegant" route.

Thanks again,

Shawn.

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:eOxh6kCAFHA.1264@TK2MSFTNGP12.phx.gbl...
> 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