RE: SQL Server 2000 Linked Server --> IBM DB2

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

From: Eric Cardenas (ecard_at_anonymous.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 02:22:43 GMT

>
> I am trying to create a linked server connection in SQL Server 2000 to
> an IBM DB2 database running on a RISC/6000. The instructions in
> Books Online (SQL Server) are a bit hazy, as it tells me that
> I NEED Host Integration Server to make the connection as a data link
first.
>
> I downloaded the trial version to see what it would do, and I
> successfully created a connection *.UDL file, but it does not tell me
> what to do after that.
>
> I do not know what kind of connection string I'm supposed to use, and
> I do not even know if I should use the 'IBM OLE DB2' provider or the
> 'Microsoft OLE DB2' provider.
>
> Can anyone help me please?
>
> Brian
------------
Hi Brian,

This article might help:

INF: Creating a Linked Server to DB2 using Microsoft OLE DB Provider for DB2
http://support.microsoft.com/?id=222937

Regards, 

--
Eric Cárdenas
SQL Server senior support professional

Relevant Pages

  • Re: Microsoft Excell Connection
    ... Use your linked server to Access then as the source by adding a SQL Server ... You should be able to add an Access Connection to a secured Access MDB ... properties enter the location of your system database. ...
    (microsoft.public.sqlserver.dts)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)