db2-linkedserver | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


dears,<br />i have done everything in my head for<br />creating linked server for db2..<br />i am giving u code list…please verify<br /><br />the driver i am using is CWBODBC.DLL (iSeries Access ODBC driver)<br />my sql server is on Windows XP and DB2 running on AS 400..<br /><br /><br /><br />exec sp_addlinkedserver @server=’S6560BCB’,<br />@srvproduct=’IBM DB2 UDB for iSeries OLEDB Provider’,<br />@catalog=’DB2′,<br />@provider=’DB2OLEDB’,<br />@provstr=’Netlib=SNA;NetAddr=;Netport=;RemoteLU=tejal;localLU=LOCAL;<br />modename=QPCSUPP;InitCat=mvxbdta;default schema=mvxbdta;<br />commit=YES;IsoLvl=NC;Accmode=;CCSID=37<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />CCodePage=1252;BinAsChar=No;<br />Data Source=dbconn_old'<br /><br /><br />exec sp_addlinkedsrvlogin ‘S6560BCB’,false,’gmm’,’tejal’,’tejal123′<br /><br />please help me out..its a big nightmare to me…<br /><br />thanx<br />jeet<br /><br /><br />
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21262706.html check these