Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    6

    Unanswered: is it possible to define in sql server linked tables as in access?

    is it possible to define in sql server linked tables to odbc data sources as it is possible to do in access?
    except Access and vfp, is there another database that allows to create linked tables to odbc data sources?

    I need to combine in a database native tables with odbc linked tables, but it would need to use a database more powerful that access or vfp

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, see sp_addlinkedserver for ideas.

    -PatP

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by rdeharo
    is it possible to define in sql server linked tables to odbc data sources as it is possible to do in access?
    except Access and vfp, is there another database that allows to create linked tables to odbc data sources?

    I need to combine in a database native tables with odbc linked tables, but it would need to use a database more powerful that access or vfp
    You can use SQL Linked servers to achieve your goals. A Linked Server can be any ODBC-compliant database for which there are adequate drivers.

    I would advise a bit of caution regarding linked servers; they work well, but use complex queries with caution as you can't always predict with certainty where the processing will occur (especially when there are joins and subqueries involved).

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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