Professional Web Applications Themes

can I access and join data from 2 sources? - ASP

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 ...

  1. #1

    Default can I access and join data from 2 sources?

    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 Guest

  2. #2

    Default Re: can I access and join data from 2 sources?

    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" <noonenowhere.com> wrote in message
    news:uz8fVZBmDHA.744tk2msftngp13.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.
    >
    >

    Manohar Kamath [MVP] Guest

  3. #3

    Default Re: can I access and join data from 2 sources?

    Thanks, I'll check that out.

    "Manohar Kamath [MVP]" <mkamathTAKETHISOUTkamath.com> wrote in message
    news:eMAzp1BmDHA.2528TK2MSFTNGP10.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" <noonenowhere.com> wrote in message
    > news:uz8fVZBmDHA.744tk2msftngp13.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 Guest

Similar Threads

  1. Data Sources
    By PhilRV6 in forum Coldfusion Database Access
    Replies: 9
    Last Post: May 22nd, 12:24 AM
  2. Restoring data sources in CF 5.0
    By owlG in forum Macromedia ColdFusion
    Replies: 2
    Last Post: June 19th, 02:20 AM
  3. The IListSource does not contain any data sources. <-- ?
    By KK in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: January 13th, 12:13 PM
  4. how to access data from 2 different sources?
    By djc in forum ASP Database
    Replies: 4
    Last Post: October 23rd, 12:15 AM
  5. how to access FreeRide sources?
    By me in forum Ruby
    Replies: 1
    Last Post: September 5th, 06:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139