All About Interop

Connecting .NET to just about anything else

Browse by Tags

Tagged Content List
  • Blog Post: Examining Perf of linked DB2 Servers in SQL 2005

    SQL As a Federation Database One of the nice things you can do with SQL Server 2005 is utilize it as a central federating data server. In this manner of usage, SQL Server acts as the gateway to connect to data that is distributed in different sources across the enterprise. There are a couple options...
  • Blog Post: Defining a DB2 as a linked server in SQL Server 2005

    This example shows how to add a remote DB2 as a linked server, using the MS OLEDB provider for DB2 (I mentioned it yesterday ). EXEC sp_addlinkedserver server='LINKEDDB2', @srvproduct='Microsoft OLE DB Provider for DB2', @catalog='DB2', @provider='DB2OLEDB', @provstr='Initial...
Page 1 of 1 (2 items)