HOME HOME   SEARCH   CONTACTS 
SSL WebGUI Hosting Powered by WebGUI
THE BEST SITE BUILDER EVER SEEN. AND IT IS FREE! UNBELIEVABLE? YES! HOW? SPONSORED BY OTHER ORGANIZATIONS.


 


Microsoft SQL Server Linked Server for IBM DB2 LUW

Working described for IBM Driver:

EXEC master.dbo.sp_addlinkedserver @server = N'DB2IBM', @srvproduct=N'IBMADB2.DB2COPY1', @provider=N'IBMDADB2.DB2COPY1', @provstr=N'Initial_Catalog=PROMO;Database=PROMO; Hostname=xxx.xxx.xxx.xxx;Port=50000;UID=promo;password=xxx'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2IBM',@useself=N'False',@locallogin=NULL,@rmtuser=N'promo',@rmtpassword='########'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2IBM',@useself=N'False',@locallogin=N'sa',@rmtuser=N'promo',@rmtpassword='########'

Working described for MS Driver:

EXEC master.dbo.sp_addlinkedserver @server = N'DB2MS', @srvproduct=N'DB2OLEDB', @provider=N'DB2OLEDB', @datasrc=N'DB282', @provstr=N'Provider=DB2OLEDB;User ID=promo;Password=xxx;Initial Catalog=PROMO;Network Transport Library=TCP;Host CCSID=1251;PC Code Page=1251;Network Address=xxx.xxx.xxx.xxx;Network Port=50000;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/Linux;Defer Prepare=False;Rowset Cache Size=0;Persist Security Info=True;Connection Pooling=True;Derive Parameters=False;Package Collection=YOUR_SCHEMA;'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2MS',@useself=N'False',@locallogin=NULL,@rmtuser=N'promo',@rmtpassword='########'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2MS',@useself=N'False',@locallogin=N'sa',@rmtuser=N'promo',@rmtpassword='########'


If you like the page - tweet and share it. Если статья понравилась - лайкайте,твитьте, делитесь.