I have installed SQL Server 2005 Standard Edition on an XP workstation here,
and wish to ETL data from our OS400 ERP System to a data warehouse in SQL.
Although Help says there is an OLEDB Provider for IBM DB2 supplied with the
SQL Server software there is not one on the DVD. I downloaded one from the MS
Downloads site but it is for installation only on Enterprise or Developer
editions.
Does anyone know if there is a DB2 database OLEDB Provider for SQL Server
Std edition?
Regards
Al

Hi

From SQL Server 2005 BOL:

To create a linked server to access a DB2 database
1.. Install Host Integration Server 2004 Client software on a computer
that is running an instance of SQL Server and select the options to install
the OLE DB Provider for DB2.

2.. Determine the connection string the OLE DB Provider for DB2 requires
to access the DB2 data source you want to query. The best way to determine a
connection string is to build a Data Link file by using the Host Integration
Server New OLE DB Data Source application. For more information, see the
Microsoft Host Integration Server 2004 documentation.

............


So, you need HIS installed bofeore it works.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"All Black" <AllBlack (AT) discussions (DOT) microsoft.com> wrote