Martin Reid
mwp.reid at qub.ac.uk
Wed Oct 8 12:28:34 CDT 2003
The format of the connection string is "Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW" not sure how this will work over DSL? If you can get me onto the DB2 system I can try it from here. I have DB2 at home but would need to install it again. Martin ----- Original Message ----- From: "Djabarov, Robert" <Robert.Djabarov at usaa.com> To: <dba-sqlserver at databaseadvisors.com> Sent: Wednesday, October 08, 2003 8:56 AM Subject: RE: [dba-SQLServer]Linked Server (DB2) Are you sure the db2 guys gave you write permissions? -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Michael Brösdorf Sent: Wednesday, October 08, 2003 10:48 AM To: dba-sqlserver at databaseadvisors.com 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!!! TIA, Michael _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com