Link Server between MS SQL SERVER 2008 R2 and DB2 8.1.12.99

Hello,

  I need to create a Link Server between MS SQL Server and DB2.

 The DB2 version is 8.1.12.99 and runs in a Windows 2000 Server.

 The MS SQL Server version is 2008 R2 and runs in a Windows 2008 Server R2 Standard.

 How can i create a link servers with this two databases ?

Thanks.
LVL 1
joe_echavarriaDatabase AdministratorAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you install the 64bit version?
You can try to check with the ODBC tool if it is listed there.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
First install the DB2 client in the SQL Server machine and then you can create the respective Linked Server. Since you're new on this I would suggest you to use the SSMS GUI to create the Linked Server as it acts like a wizard where you can provide all the necessary information for the creation of the linked server.
If you need further help, try to follow this article
0
 
joe_echavarriaDatabase AdministratorAuthor Commented:
The DB2 OLEDB  can works on MS SQL SERVER Standard Edition ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Any OLEDB driver works on Windows.
Linked Server doesn't have any kind of restrictions as only load and uses the provided OLEDB driver and the behaviour doesn't change for any SQL Server Edition, so yes, it will work.
0
 
joe_echavarriaDatabase AdministratorAuthor Commented:
I have installed the DB2 Client.    For some reason i do not see the provider installed.
db2-link-servers.jpg
0
 
joe_echavarriaDatabase AdministratorAuthor Commented:
Is the Microsoft OLE Provider for DB2 able to run in MS SQL Server Standard ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.