ODBC Connection to Extract Data from DB2 to MS SQL Server 2005 Standard

I'm trying to create an ODBC connection to DB2 so I can import data into MS SQL Server 2005 Standard Edition.

I've installed the DB2 Run Time Client on my machine, but am not sure how to proceed.  The DB2 data based I'm connecting to is on a remote site so I do not have any information on the details of the system.
tfewster500Asked:
Who is Participating?

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

x
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.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> The DB2 data based I'm connecting to is on a remote site so I do not have any information on the details of the system.

If you don't have any information about your DB2 server, ip or name, database name, TCP port on which DB2 is listening and all, then you can't connect it from SQL Server at all..
0
tfewster500Author Commented:
Sorry,

I do have:

Server Name, IP Address, Port and Database Name.  IT department at the remote machine is getting me a User Name and Password.

Is there anything else I need?  If I have everything, how do I create the ODBC connection?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Ok, Make sure you have OLEDB drivers for DB2 installed in your SQL Server machine from here

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/DB2OLEDB.exe

And then create a System DSN to your DB2 database so that you can connect to that DB2 database using this DSN.
0
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

tfewster500Author Commented:
This DB2OLEDB is only for Enterprise and Developer editions of SQL Server.

Some searching on Google indicated that I need the DB2 Run Time Client which I have installed, but not sure how to use.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
The link provided above is just a driver and you can install in in SQL Server machine and use it out..
No issues and you can also install Run time client which would install drivers provided by IBM in your SQL Server machine.

Once done, create System DSN in your SQL Server machine
0
tfewster500Author Commented:
When I install this, it gives me a message that "Upgrade Partially Successful".  It was not completed as the proper version of SQL Server is not installed.

When I try now try to create a System DSN, I cannot see any Microsoft OLE DB Provider for DB2?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Upgrade Partially Successful

Then it is not completely installed..
Try uninstalling the driver completely and reinstall it again which should work now.
0

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
Microsoft SQL Server 2005

From novice to tech pro — start learning today.