Linked Server on SQL2000 to DB2 - desperate...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bretl Andy (andreas.bretl_at_brainlab.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 12:47:44 +0200

Hi All,
I am close before throwing the machine out of the window.
I tried to establish a linked server on our SQL2000 server pointing to a DB.

EXEC sp_addlinkedserver
@server = 'DB2',
@srvproduct = 'IBM OLE DB Provider for DB2 Servers',
@provider = 'IBMDADB2',
@provstr='DSN=JDE_PROD;UID=XXXX;PWD=XXX;DATABASE=JDE_PROD;'

EXEC sp_addlinkedsrvlogin 'DB2', false, NULL, 'XXX', 'XXXX'

If I query the LS using query analyzer or the Enterprise Manager both start
to hang, never responding again.
To be honest I am quite new to this topic but I read a lot and also tried a
lot ;)

Some articles talk about SNA Servers to be installed first, others about
some client tools.
I am confused by now...

Could anybody please be so kind and tell me how to connect the DB2 as a
linked server?
Is my statement wrong, and if so how should it look like? Why does the
application start to hang? Do I really need to install additional software
to do so?

Our DB2 expert also taked about software necessary to access the DB2
mainframe. Any ideas?

Thanks a lot in advance and belive me, any hints are highly appreciated ;)

Seize the Day

Andy

Andreas Bretl
andreas.bretl@brainlab.com

Relevant Pages

  • Re: Source table filtering in DTS by target table values.
    ... You create the linked server the other way around. ... it is from SQL Server to DB2 ... I doubt that we can create a linked server on an DB2 database ... If ActiveX script can read thorugh A and reject non-relevant rows ...
    (microsoft.public.sqlserver.dts)
  • issue with openquery
    ... I have set up a linked server to DB2 AS/400 as the following: ... and then ran the open query: ... OLE DB error trace [Non-interface error: OLE DB provider unable to process ... But if I directly run the query through the DB2 client on my SQL Server, ...
    (microsoft.public.sqlserver.server)
  • Update
    ... queries against a linked server (DB2 UDB). ... Servers security properties, ... ID and password for the linked server. ... to be that the job owner is a SQL Server login that is not ...
    (microsoft.public.sqlserver.security)
  • RE: Access SQL server from AS/400 DB2
    ... as "Linked Server" in AS/400 DB2. ... Based on my scope, unfortuantely, SQL Server has no such funcationality to ... I will do more research try to find whether IBM DB2 will ... Online Partner Support Specialist ...
    (microsoft.public.sqlserver.connect)
  • Re: DTS Import From AS/400 DB2
    ... DB2 with no success. ... Server or MS Host Integration Server to configure the data source for the OLE ... DB provider. ... I was able to create a linked server using ...
    (microsoft.public.sqlserver.dts)