tfewster500
asked on
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.
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.
ASKER
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?
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?
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.
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.
ASKER
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.
Some searching on Google indicated that I need the DB2 Run Time Client which I have installed, but not sure how to use.
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
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
ASKER
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?
When I try now try to create a System DSN, I cannot see any Microsoft OLE DB Provider for DB2?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..