Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Location
    Atlanta
    Posts
    58

    Question Unanswered: Proxy table in Sybase that points to MS SQL Server

    Can anyone point me to a book or give me a cookbook recipe for creating a proxy table in Sybase 12.5 that points to a MS SQL Server 2005 table?

    I have searched the forum, Sybooks, and BOL and it appears that it can be done.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Proxy table?
    I think you want to look at linked servers (in MSSQL)
    George
    Home | Blog

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Enterprise Connect Data Access Sold as an ASE option provides ASE access either directly or via ODBC connections to IBM DB2, Oracle, SQL Server and any ODBC-compliant DB

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Quote Originally Posted by georgev
    Proxy table?
    Yes, thats what it is called on Sybase ASE.

    Glossary

    proxy table

    A local table that has been mapped to a table on a remote server. The proxy table contains metadata and is used to access the remote table as if it were a local table.

  5. #5
    Join Date
    Jan 2005
    Location
    Atlanta
    Posts
    58

    SQL code needs to run on Sybase to get data from MSSQL

    Thanks pdreyer. That is what I was looking for.

    I should have highlighted the specific need to run some SQL code on Sybase to get data from MS SQL.

    I am assuming that linked servers created on MS SQL allows MS SQL code to get data from or push data to Sybase, but does not allow Sybase to get data from or push data to MS SQL.

    Correct?

Posting Permissions

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