Create a Linked Server Using IBM OLEDB Provider

• Chubbs

  SSC Enthusiast

  Points: 191

  More actions

  November 16, 2017 at 11:42 am

  #409779

  Hello!

  I am hoping someone can help me solve an issue I have been trying to solve for several weeks now. I have been trying to create a linked server to our DB2 database running on version 11.1 and I have been unable to do so. I have been attempting to use the Microsoft OLE DB provider for DB2 to connect to the database use Microsoft Data Access Tools 5.0 but have been unsuccessful. I believe the reason being is because the SQL account we have for the DB2 server is read-only. Unfortunately, this is beyond our control because the vendor we purchased the product from has given us a read-only account as designed by their product. Any updates we need to do to our data is done through a custom API they have built and is executed within the system. I was able to create an ODBC but it is extremely slow and there is no way I plan on creating reports using this type of connection. So, I am hoping I can use the IBM OLE DB Provider instead. I apologize for the mouth full.

  I am attempting to enter in the following information in my posted image to connect to the server but it states that it cannot find the remote host.

  Cannot initialize the data source object of OLE DB provider "IBMOLEDB.IBMDBCL1" for linked server "DB2_OLEDB".
  OLE DB provider "IBMOLEDB.IBMDBCL1" for linked server "DB2_OLEDB" returned message " SQL1336N The remote host "D0042T04" was not found. SQLSTATE=08001
  ". (.Net SqlClient Data Provider)
  
  I know I am doing something wrong and could use some help in pointing me in the correct direction. Any help on this would be greatly appreciated and thanks for taking the time to read this post!

• goher2000

  SSCertifiable

  Points: 5479

  More actions

  November 17, 2017 at 12:13 pm

  #1968591

  I suppose server is reachable from sql server box. try ping or telnet to check if port is open, if it is then play with "Server Options" in "New Linked Server" window

• Chubbs

  SSC Enthusiast

  Points: 191

  More actions

  November 17, 2017 at 1:38 pm

  #1968600

  goher2000 - Friday, November 17, 2017 12:13 PM

  I suppose server is reachable from sql server box. try ping or telnet to check if port is open, if it is then play with "Server Options" in "New Linked Server" window

  Thanks for the reply!

  Correct. I currently have the ODBC connection on the server which is using the same port number to access the database, but ideally I would like to use OLE DB.