470,831 Members | 1,668 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,831 developers. It's quick & easy.

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.
Jul 19 '05 #1
2 3247
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
www.dotnetbooks.com
"djc" <no***@nowhere.com> wrote in message
news:uz*************@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.

Jul 19 '05 #2
djc
Thanks, I'll check that out.

"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:eM**************@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
www.dotnetbooks.com
"djc" <no***@nowhere.com> wrote in message
news:uz*************@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.


Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Jegger | last post: by
4 posts views Thread by Lefteris | last post: by
9 posts views Thread by Tony Lee | last post: by
52 posts views Thread by Neil | last post: by
1 post views Thread by DeanL | last post: by
1 post views Thread by =?Utf-8?B?VGVycnk=?= | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.