The HCO for SQL Server Tools have the following system requirements:
- OS: Windows XP Professional, Windows Vista Business, Windows Server
2003/2008
- Microsoft .NET Framework 3.5
- SQL Server 2008 Enterprise Edition, or Developer Edition.
- For the connection to DB2 on z/OS
the recommended provider is the Microsoft OLE DB Provider for DB2, which is
available in the SQL Server 2008 Feature Pack download. An alternative DB2 connection is IBM OLE DB Provider (through DB2 Client). Note that the Microsoft provider is recommended, as all HCO for SQL Server tools may not function at their best with the IBM provider.
- For SQL Server 2008,
the recommended provider for use with schema object creation is the .NET provider for
SQL Server (System.Data.SqlClient) which is available with the .NET framework.
For data transfers and application use at runtime the recommended provider is the Microsoft SQL Server
2008 Native Client ODBC driver (SQL Server Native Client 10).