In the past we researched this many times before and tried extensively in the past on SQL 2000 and always failed to get linked servers working Via IBM's OLE DB providers. This left us having to use Microsoft's ODBC drivers instead and then a rather clunky manually written Openquery method to query data despite having read that this could be quite slow in comparison.
Anyway we are finally upgrading our SQL server to 2008 (Standard Edition AP Clusters, we had Enterprise before but didn't use anything bar clustering from this edition) I decided to have another go, having discovered that Microsoft think we ought to pay Enterprise edition money if we want to use their OLE DB drivers for DB2 I was even more determined to get IBM's (included free with Iseries Access) own OLE DB drivers working.
Anyway I have finally puzzled out settings that work and its actually quite easy through Server Management Studio. I thought I would post details here for anyone else who has struggled to get this working. Similar settings should in theory work through SISS though I haven't done enough with SISS yet to give details!
First Open Server Management Studio (SMS) and expand out
Server Objects, then Linked Servers, then Providers.
Right click Properties on the Providers you want to use (IBM ones start IBM, they are DA400, DASQL and DARLA, The f
View Complete Post