none
Unable to connect to linked server pointing to DB2

    Question

  • I have created a linked server pointing to DB2 and it works well when connecting to Server1.

    But linked server 2 pointing to Server2, I am unable to test the connection, It throws me following error,

    The test connection to the linked server failed.

     

    ------------------------------

    ADDITIONAL INFORMATION:

     

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

     

    ------------------------------

     

    Cannot initialize the data source object of OLE DB provider "DB2OLEDB" for linked server "DB2".

    OLE DB provider "DB2OLEDB" for linked server "DB2" returned message "The host resource could not be found. Check that the Initial Catalog value matches the host resource name. SQLSTATE: HY000, SQLCODE: -360". (Microsoft SQL Server, Error: 7303)

     

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476

     

    Can anyone tell me, is there anything I need to do on DB2 server side to allow linked server connection?

    Thanks!

    • Edited by mahajansp Sunday, October 06, 2013 3:24 AM
    Sunday, October 06, 2013 3:23 AM

Answers

All replies