none
윈도우 서버 2008에 ms sql server2014를 설치하고, IBM DB2를 링크 RRS feed

  • 질문

  • 윈도우 서버 2008에 ms sql server2014를 설치하고, IBM DB2를 링크하려고 합니다.

    아래 방법으로 했는데... 커넥션은 되었다고 하는데 셀렉트가 안됩니다.

    무얼 잘못한 걸까요?

    /****** Object:  LinkedServer [B]    Script Date: 2016-02-04 오전 10:56:31 ******/
    EXEC master.dbo.sp_addlinkedserver @server = N'B', @srvproduct=N'', @provider=N'DB2OLEDB', @provstr=N'Provider=DB2OLEDB;User ID=아이디;Password=패스워드;Initial Catalog=SMDB;Network Transport Library=TCPIP;Host CCSID=933;PC Code Page=949;Network Address=아이피어드레스;Network Port=50000;Package Collection=MSDB2COL;Default Schema=smdb;Connect Timeout=15;Units of Work=RUW;DBMS Platform=DB2/AS400;Use Early Metadata=False;Defer Prepare=False;DateTime As Char=False;Rowset Cache Size=0;Binary CodePage=0;Max Pool Size=100;Datetime As Date=False;AutoCommit=True;Authentication=Server;Decimal As Numeric=False;Derive Parameters=False;LoadBalancing=False;Persist Security Info=False;Cache Authentication=False;Connection Pooling=True;'
     /* For security reasons the linked server remote logins password is changed with ######## */
    EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'B',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'collation compatible', @optvalue=N'false'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'data access', @optvalue=N'true'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'dist', @optvalue=N'false'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'pub', @optvalue=N'false'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'rpc', @optvalue=N'false'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'rpc out', @optvalue=N'false'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'sub', @optvalue=N'false'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'connect timeout', @optvalue=N'0'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'collation name', @optvalue=null
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'lazy schema validation', @optvalue=N'false'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'query timeout', @optvalue=N'0'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'use remote collation', @optvalue=N'true'
    GO

    EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'remote proc transaction promotion', @optvalue=N'true'
    GO

    2016년 2월 4일 목요일 오전 1:28