How to add an IBM DB2 server to SQL Server's Linked Server -
from .net, i'm able connect db2 database: first include reference "ibm.data.db2.iseries" then create new ibm.data.db2.iseries.idb2connection. connection string is datasource=chadb2server;userid=myusername;password=mypassword; then create ibm.data.db2.iseries.idb2command, , on. now i'm trying sql server 2005 access same data directly. in sql server management studio, right-click on linked servers, , select "new linked server..." linked server: chadb2server provider: ibm ole db provider db2 product name: ??? data source: chadb2server provider string: datasource=chadb2server;userid=myusername;password=mypassword; location: ??? i can leave location blank, product name can't empty , don't know fill in here. on security tab, select "be made using security context" , repeat userid , password. the linked server gets created, when try expand catalogs / default / tables, error message: ole db provider ...