http://snippets.dzone.com/posts Sat, 06 Sep 2008 13:53:01 GMT DZone Snippets: server code http://snippets.dzone.com/posts/show/3731 1. Install DB2 on MSSQL machine <br />2. Start Configuration Assistant. Add a new database mapping to the desired target DB2 database. Select option to create a System DSN along the way. <br />3. Start Microsoft’s ODBC Data Source Administrator. There should be a System DSN created from the previous step. Configure it with the userid/password for the target DB2 database. <br />4. Create linked server in MSSQL: EXEC sp_addlinkedserver @server = 'TMON', @srvproduct = '', @provider = 'MSDASQL', @datasrc = 'TMON' <br />5. Map access to linked server: EXEC sp_addlinkedsrvlogin 'TMON', 'false', NULL, 'db2admin', 'db2admin' <br />6. 2 ways to test the link: SELECT * FROM TMON..DB2ADMIN.USERS -- use uppercase for server, schema, table names SELECT * from OPENQUERY (TMON,'select * from users') <br /> <br />Notes: <br /> * TMON is the remote DB2 database, also used as the DSN name. <br /> * Remote DB2 server uses access id: db2admin and password: db2admin <br /> * USERS is a table in the remote DB2 database Mon, 26 Mar 2007 08:49:53 GMT http://snippets.dzone.com/posts/show/3731 wjchay (Chay Weei Jye)