Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: query to multiple ms sql servers

    Hi!!

    Is it possible to make a query to multiple ms sql servers from odbc?

  2. #2
    Join Date
    Mar 2009
    Posts
    11
    You'll have to have multiple connections and manage them.
    But its been awhile since I've used ODBC, so I'm unsure (I don't know if there is some type of limit).

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you can connect to as many servers as you wish to and have access to
    as dgreenhouse points out you will need to have a connection for each server, and your ISP/DBA may be bone to keen if you start opening up multiple connections per script as connections are expensive in time and resources.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Mar 2009
    Posts
    2
    Thanks for your replies!! But I need to join tables from diferent servers (cross datbase??, i dont know if is correct in english), at the moment only two, so i hope there are not going to be resurce problems.

    I've made a linked server in one of the ms sql servers that points to the other, and then made the query, but i'd like to know if there is some way to make the query directly. I'm making the query from php.
    I'v seen that in pg you can use dblink to do it.

    Thanks!!!!!

Posting Permissions

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