Link Server between MS SQL SERVER 2008 R2 and DB2


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

 The DB2 version is 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 ?

joe_echavarriaDatabase AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
joe_echavarriaDatabase AdministratorAuthor Commented:
The DB2 OLEDB  can works on MS SQL SERVER Standard Edition ?
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.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

joe_echavarriaDatabase AdministratorAuthor Commented:
I have installed the DB2 Client.    For some reason i do not see the provider installed.
joe_echavarriaDatabase AdministratorAuthor Commented:
Is the Microsoft OLE Provider for DB2 able to run in MS SQL Server Standard ?
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.