Re: Where can I find a DB2 OLE DB provider for SQL Server 2000?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The tool you seek is located here...
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Feature Pack for Microsoft SQL Server 2005 - November 2005

Microsoft OLEDB Provider for DB2
The Microsoft OLE DB Provider for DB2 is a COM component for integrating
vital data stored in IBM DB2 databases with new solutions based on Microsoft
SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server
developers and administrators can use the provider with SQL Server
Integration Services, SQL Server Analysis Services, Replication, and
Distributed Query Processor. Run the self-extracting download package to
create an installation folder. The single setup program will install the
provider and tools on both x86 and x64 computers. Read the installation
guide and Readme for more information.

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:d8sdg2lrlu9pbjoliq1gbo5leeb16i7250@xxxxxxxxxx
Jason,

I believe that provider comes with Host Integration
Services.

-Sue

On Mon, 11 Sep 2006 15:26:02 -0700, Jason Barnett
<JasonBarnett@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I'm trying to link SQL Server 2000 to DB2 UDB 7.2, using OLE DB. However,
I've gotten an error message stating that the DB2 OLE DB provider I'm
using
does not implement a required interface. I've also read that there is a
Microsoft DB2 OLE DB provider, but I can't find it. Does anyone know
where I
might find it?



.

Relevant Pages

  • Re: SQL 2005 and Linked Server for DB2
    ... Microsoft does not OLEDB for ODBC in 64-bit environment. ... The OLE DB provider "MSDASQL" has not been registered. ... The other problem is about the drive Microsoft OLEDB provider for DB2 ...
    (microsoft.public.sqlserver.setup)
  • Re: Informix Information
    ... DB2 and the respective audiences for IBM products as opposed to SQL Server ... that Microsoft can't even agree on their own definitions of SQL. ...
    (comp.databases.informix)
  • Linked Server Update Problem
    ... I am getting an error trying to update a table in DB2 ... via SQL Server using a Linked Server. ... When I try to Query using four-part names I get the ... 7399 OLE DB Provider 'MSDASQL' reported an error. ...
    (microsoft.public.sqlserver.programming)
  • Re: Impossible dextraire les informations de catalogue.
    ... Erreur de liaison de données Microsoft ... to connect using ADO to SQL Server 2000 i use Microsoft OLE DB Provider ...
    (borland.public.delphi.database.ado)
  • Re: Where can I find a DB2 OLE DB provider for SQL Server 2000?
    ... Feature Pack for Microsoft SQL Server 2005 - November 2005 ... Microsoft OLEDB Provider for DB2 ...
    (microsoft.public.sqlserver.connect)