Query Remote Databases


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Query Remote Databases

  1. #1
    Steven Guest

    Query Remote Databases


    Hi
    I want to execute a distributed join between tables A and B which are on
    different sites. I run my query at site C and it's implemented in java with
    the necessary JDBC driver etc. How do I transfer table A to site of table
    B to perform then join there?

    Thx

  2. #2
    Francisco Espinoza Guest

    Re: Query Remote Databases


    Hi Steven,

    You'll need, register a server in another server like Linked Server. You
    can do this, using Enterprise Manager, or T-SQL in Query Analizer. Try to
    find information about LINKED SERVERS AND REMOTE SERVERS.


    By
    Francisco Espinoza


    "Steven" <stevenchung@yahoo.com> wrote:
    >
    >Hi
    > I want to execute a distributed join between tables A and B which are

    on
    >different sites. I run my query at site C and it's implemented in java with
    >the necessary JDBC driver etc. How do I transfer table A to site of table
    >B to perform then join there?
    >
    >Thx



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center