Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Data Access

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?
[308 byte] By [TLex] at [2007-12-25]
«« Does anyone know of a web based SQL Query tool?
»» Thread looping with EndInvoke and InvokeRequired
# 1

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

WaseemBasheer-MSFT at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 2

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

MichaelMogensen at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Data Access...
SQL Server
SQL Server Data Access

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified