The information in this article applies to:
SYMPTOMSWhen you run a four-part name query such as the following SELECT * FROM LinkedServer name.Catalog.Schema name.Table nameusing the Microsoft OLE DB Provider for DB2 from a linked server to DB2 on OS/390, the following error might be reported by the SQL Server:
RESOLUTIONTo resolve this problem, obtain the latest service pack for SNA Server version 4.0. For additional information, please see the following article in the
Microsoft Knowledge Base: Q215838 How to Obtain the Latest SNA Server Version 4.0 Service Pack WORKAROUNDUse pass-through queries with OPENQUERY or OPENROWSET. For examples of linked server queries to DB2 using OPENQUERY or OPENROWSET, please refer to the following article in the Microsoft Knowledge Base: Q222937 Creating a Linked Server to DB2 using Microsoft OLE DB Provider for DB2 STATUSMicrosoft has confirmed this to be a problem in Microsoft SNA Server version 4.0 Service Pack 2. This problem was first corrected in SNA Server version 4.0 Service Pack 3. Additional query words: Mainframe ODBC MSDB2OLE MVS DB2/400
Keywords : sna4sp3fix |
Last Reviewed: September 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |