November 16, 2017 at 11:42 am
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!
November 17, 2017 at 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
November 17, 2017 at 1:38 pm
goher2000 - Friday, November 17, 2017 12:13 PMI 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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy