data access to UNIDATA | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

data access to UNIDATA

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!

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
This posting is provided AS IS with no rights for the sake of knowledge sharing.