Skip to main content

Posts

Showing posts from September, 2018

Create and query DB2 Linked Server in SSMS

Data Sources are heterogeneous and time to time you might require to query from a data base while being in another, in this case we will query a DB2 Database from SQL Server Management Studio. DB2 Connector First you need to download the DB2 connector to be able to connect to a DB2 Source, in order to do that go to this URL https://www.microsoft.com/en-us/download/details.aspx?id=52676 Select download and choose “ ENU\x64\DB2OLEDBV5_x64.msi ” to download and install the DB2 connector. Configure a Linked Server You can create a linked server to query a DB2 Data base from SSMS, in order to create a linked server go to “Server Objects” and expand it then right click “Linked Servers” and select New Linked Server, here you need to provide the following information. Below is an example for a provider string and you should insert all the relevant values for them. Data Source = ****; User ID=***;Password=*****;Initial Catalog=***;Provider=DB2...