[dba-SQLServer]Linking to DB2

Martin Reid mwp.reid at qub.ac.uk
Wed Oct 8 12:39:13 CDT 2003


Hope this  to the right list

http://www.databasejournal.com/features/mssql/article.php/1756161

>From MS

EXEC sp_addlinkedserver
   @server='DB2',
   @srvproduct='Microsoft OLE DB Provider for DB2',
   @catalog='DB2',
   @provider='DB2OLEDB',
   @provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network
Address

You need to register to see this one

http://www-level3.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20681782.html



Martin



More information about the dba-SQLServer mailing list