can I access and join data from 2 sources?

[djc]

I need to use data from multiple tables that are located in 2 different
databases. Most of the tables are in SQL Server 2000 but 1 one the tables I
need to include in my query resides in an Access2002 mdb file.

I need to do this via ASP/ADO on IIS5.

How do I combine (join in a query) tables from different databases? they
are each opened from a different connection object? I have only had to
access tables from one source before and I used the recordset.Open "sql
statement", connectionObjectVariable syntax.

Can I this even be done?

any help is appreciated. Thanks.

[Manohar Kamath [MVP]]

The best way to do this is by creating so called "Linked servers" in SQL
Server. Doing so, you can query data across multiple servers, even disparate
types (SQL, Access, Foxpro, etc.) as if they were all single source of data.
Look for "Linked servers" in SQL books online.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"djc" <noone@nowhere.com> wrote in message
news:uz8fVZBmDHA.744@tk2msftngp13.phx.gbl...

> I need to use data from multiple tables that are located in 2 different
> databases. Most of the tables are in SQL Server 2000 but 1 one the tables

I

> need to include in my query resides in an Access2002 mdb file.
>
> I need to do this via ASP/ADO on IIS5.
>
> How do I combine (join in a query) tables from different databases? they
> are each opened from a different connection object? I have only had to
> access tables from one source before and I used the recordset.Open "sql
> statement", connectionObjectVariable syntax.
>
> Can I this even be done?
>
> any help is appreciated. Thanks.
>
>

[djc]

Thanks, I'll check that out.

"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message
news:eMAzp1BmDHA.2528@TK2MSFTNGP10.phx.gbl...

> The best way to do this is by creating so called "Linked servers" in SQL
> Server. Doing so, you can query data across multiple servers, even

disparate

> types (SQL, Access, Foxpro, etc.) as if they were all single source of

data.

> Look for "Linked servers" in SQL books online.
>
> --
> Manohar Kamath
> Editor, .netBooks
> [url]www.dotnetbooks.com[/url]
>
>
> "djc" <noone@nowhere.com> wrote in message
> news:uz8fVZBmDHA.744@tk2msftngp13.phx.gbl...

> > I need to use data from multiple tables that are located in 2 different
> > databases. Most of the tables are in SQL Server 2000 but 1 one the

tables

> I

> > need to include in my query resides in an Access2002 mdb file.
> >
> > I need to do this via ASP/ADO on IIS5.
> >
> > How do I combine (join in a query) tables from different databases?

they

> > are each opened from a different connection object? I have only had to
> > access tables from one source before and I used the recordset.Open "sql
> > statement", connectionObjectVariable syntax.
> >
> > Can I this even be done?
> >
> > any help is appreciated. Thanks.
> >
> >

>
>