Connect WebSphere and Java applications to SQL Server

FYI: The MS JDBC Driver is completely tested by IBM for use with WebSphere App Server v6.1 and v7.0. From the IBM Announcement for WebSphere Application Server v7.0:  WebSphere Application Server V7.0 does not include the WebSphere Connect JDBC driver that had been provided in WebSphere Application Server V6.1. To replace the functionality provided by…

2

VS2005 support for SQL 2008 CTP5

Visual Studio 2005 Support for SQL Server 2008 CTP is now publicly available. Download Center links: SQL Server 2008 CTP, November 2007 – this is the “Community Tech Preview” (CTP5) of SQL 2008. Visual Studio 2005 Support for SQL Server 2008, CTP  – this is the patch you can apply to Visual Studio 2005, to allow…

1

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…

1

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 Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;’   You…

3