SQL Server Performance

data access to UNIDATA

Discussion in 'SQL Server 2005 Integration Services' started by tboonleong, Dec 25, 2006.

  1. tboonleong Member

    Has anyone managed to set up an IBM Universe database environment as a linked server to MS SQL 2005?

    If so please convey how you got it done. Thanks!
  2. satya Moderator

    There shouldn't be any issue as compared to SQL 2000 version using UDB data access, refer to ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uas9/html/523234bb-50be-4c9c-9f9f-d70aa01f5df8.htm BOL topic.

    Also recently I have seen information from MS Support such as that DB2 stored procedures are not supported via linked server.
    It is implicitly documented in the last sentence of this excerpt from BOL for SQL Server 2005, in the chapter for SP_ADDLINKEDSERVER:

    Creates a linked server. A linked server allows for access to distributed, heterogeneous queries against OLE DB data sources. After a linked server is created by using sp_addlinkedserver, distributed queries can be run against this server. If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed.


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page