• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

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.
0
tfewster500
Asked:
tfewster500
  • 4
  • 3
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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 & ArchitectCommented:
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
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 & ArchitectCommented:
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 & ArchitectCommented:
>> Upgrade Partially Successful

Then it is not completely installed..
Try uninstalling the driver completely and reinstall it again which should work now.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now