DB2OLEDB for SQL Server 2005 Standard Edition

The Microsoft OLEDB provider for DB2 (DB2OLEDB) is available in the "Feature Pack for SQL Server 2005 – April 2006." The installation routine, however, will only install on the enterprise edition or the developer edition. Is the DB2OLEDB provider not available for SQL Server 2005 standard edition?

I just went through the README.htm that comes with the installation of DB2OLEDB and it explicitly states that:

The Microsoft OLE DB Provider for DB2 is for use exclusively with Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Developer Edition and Microsoft SQL Server 2005 Evaluation Copy.

So I believe the behaviour you are seeing is expected.

Thanks

Waseem Basheer

|||

If you want a Microsoft OLEDB provider for DB2 you have to install client tools from Host Integration Server. You can choose it under custom install.

i