Tuesday, March 27, 2012

DB2 and SQL 2005

I have a SQL 2005 server. I want to make calls to a DB2 server to retrieve a list of rows from a table. How can I access the DB2 server from Microsoft SQL Server Management Studio?You can either use a linked server with direct four-part notation access or use the OPENQUERY or OPENDATASOURCE to access the source.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment