AW: [dba-SQLServer]Linked Server (DB2)

Michael Brösdorf michael.broesdorf at
Wed Oct 8 12:52:48 CDT 2003

Yep, if I link the tables in question to an Access db, it works fine!


-----Ursprüngliche Nachricht-----
Von: dba-sqlserver-bounces at
[mailto:dba-sqlserver-bounces at]Im Auftrag von
Djabarov, Robert
Gesendet: Mittwoch, 8. Oktober 2003 17:56
An: dba-sqlserver at
Betreff: RE: [dba-SQLServer]Linked Server (DB2)

Are you sure the db2 guys gave you write permissions?

-----Original Message-----
From: dba-sqlserver-bounces at
[mailto:dba-sqlserver-bounces at] On Behalf Of Michael
Sent: Wednesday, October 08, 2003 10:48 AM
To: dba-sqlserver at
Subject: [dba-SQLServer]Linked Server (DB2)

Dear group,

we have SQL Server 2000 running in our office. We need to read/write data
from/to a DB2-database stored elsewhere. The physical connection is set up
using a DSL-line.

I want to set up the DB2-database as a linked server in SQL-Server. But I
was only partly successfull. I can read data from the tables/views but can
not write to them. I tried the DB2-ODBC-Driver from the DB2-Client
(installed on the SQL-Server-machine) and the DB2-Drivers (ODBC/OLE-DB) from
Microsoft (which are part of the Host Integration Server). The connection is
set up to use TCP/IP (I don't even know what system the DB2-database is
running on...).

The connection properties ask for a connection string, but I don't have a
clue how to built that.

Could anyone point me in the right direction here (as to where to look for
information)? I tried the Microsoft Knowledge Base (which provides _some_
information) and IBM's website (which states, that "is is possible to create
a linked server in MS SQL Server 2000 that points to a DB2-database" - a
very usefull piece of information indeed...).

Please Help!!!



dba-SQLServer mailing list
dba-SQLServer at

dba-SQLServer mailing list
dba-SQLServer at

More information about the dba-SQLServer mailing list