IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
I am trying to create a linked server from MSSQL 2014 to DB2 11.1 I am able to create one linked server and get it to work with one DB. I have not been able to figure out how to add additional catalogs(DB's). Is it possible to use just one linked server for multiple databases.
I tried to connect to db2 11.1 from sqlserver 2016 using IBMOLEDB driver. It works partially. i.e I can get table column headers but having issues in getting data.
I did it through below TSQL:
Create a ODBC system DSN to connect to a db2 database and test the connection. My DSN name is "test"
My db2 11.1 database is also named "test".
I appreciate your feedback. I am new to DB2 and still learning but i would verify the permissions you have set for your linked server account as it looks like maybe you don't have them set properly.