Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > can I access and join data from 2 sources?

Reply
Thread Tools

can I access and join data from 2 sources?

 
 
djc
Guest
Posts: n/a
 
      10-21-2003
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.


 
Reply With Quote
 
 
 
 
Manohar Kamath [MVP]
Guest
Posts: n/a
 
      10-21-2003
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>



 
Reply With Quote
 
 
 
 
djc
Guest
Posts: n/a
 
      10-22-2003
Thanks, I'll check that out.

"Manohar Kamath [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.
> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
XML data access or DB data access ? Savvoulidis Iordanis ASP .Net 2 01-07-2009 10:47 PM
You must join New York Paid To Read !!!!!!! NewYork PTR is online!!! JOIN NOW!!!!!! Alan Silver ASP .Net 0 06-05-2006 03:27 PM
list.join()... re.join()...? Do they exist? (newbie questions...) googleboy Python 1 10-01-2005 12:56 PM
How to join aspnet_Profile and aspnet_Users and get usable data. RedEye ASP .Net 0 09-01-2005 04:41 PM
How to join aspnet_Profile and aspnet_Users and get usable data. RedEye ASP .Net Security 0 09-01-2005 04:41 PM



Advertisments