MS Sql Server 2005 Standard Edition to DB2

I'm trying to import data from a DB2 database to SQL Server 2005.

I'm having trouble figuring out how to create and ODBC connection.  I'm using the STANDARD Edition of SQL Server so the DB2OLEDB installation does not work (I've reviewed several posting on this as a solution).

How can I go about this?
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.

momi_sabagCommented:
download a db2 client from ibm website
http://www-01.ibm.com/software/data/db2/linux-unix-windows/download.html

the client will include the installation of  db2 odbc driver
once it is installed you can configure an odbc data source and access it from sql server using standard sql server odbc data source
0
tfewster500Author Commented:
I'm assuming I should download:

Data Server Client Packages
Download IBM Data Server Packages, including client tools, runtime client and the latest drivers for JDBC and SQLJ, ODBC and CLI, and add-ins for Visual Studio.
0
tfewster500Author Commented:
OK, I have this installed.

Is there any information on how to create a connection?

Not sure what to put into the Database Source Name, Database Alias and Description that are on the first step of creating a System DSN.
0
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

momi_sabagCommented:
source name is the database name
database alias is how you want it to be called
you can put the same for both fields
description is optional
0
tfewster500Author Commented:
OK,

1)  I add the name of my database as the "Data Source Name"
2) Next to the "Database Alias" drop down, I click on the Add button.
3) I add in a description and provide a User ID and Password.
4) There is an Advanced Settings tab on this page, but I do nothing on this.
5) I click on OK and the ODBC connection is created.

When I click on the ODBC connection and select "Connect" it says.  It says "The database alias name or database name "" could not be found.

In this step up, I have not provided a server name, IP address, port or any other information.  Does this need to be set up on the Advanced Settings tab?
0
momi_sabagCommented:
do you have a db2 client on your machine?
if so, you will need to catalog a db2 database using the client configuration assistant
(it will ask for ip and port)
go
start -> programs -> IBM DB2-> configuration tools -> configuration assistant

and use the wizard to add the database
once it is catalog, use it alias in the odbc definition
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.