ODBC to DB2 on AIX

How do I create an ODBC connection to DB2 on AIX, so that I can write passthrough queries from Access to it?  All I have is an AIX ID and password.  Do I need to get an IP address or something?  How about a DB2 driver?

In answering this question, please pretend I am a complete idiot.  I won't be offended.  I am not nearly as technically advanced as most of you.

Thanks!!!!
StumpedAndGratefulAsked:
Who is Participating?
 
momi_sabagConnect With a Mentor Commented:
you need to download the db2 client
it can be downloaded for free from ibm:
http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg24026929
either windows 32 bit or 64 bit, depends on your system
after you install it, you will  have a db2 odbc driver on your system, so accessing db2 on aix will be just as accessing any other database on a remote machine (you will need to know the ip address and port number of that db2)
0
 
xsamirCommented:
use MS access 2010 it's will help u
0
 
StumpedAndGratefulAuthor Commented:
I'm stuck with 2007.  It's a company project.
0
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.

 
StumpedAndGratefulAuthor Commented:
momi sabaq,

Thanks.  I think you have me on the right track.  I downloaded the driver (I thought), but it does not appear in my ODBC window as a driver.  Any idea as to what I need to do?

Thanks!

Eric
0
 
momi_sabagConnect With a Mentor Commented:
did you install the db2 client? or did you download just the driver?
0
 
StumpedAndGratefulAuthor Commented:
I just downloaded the driver.  I have to install a DB2 client too?  I guess I'd have to pay for that?

Thanks,

Eric
0
 
momi_sabagCommented:
the db2 client is totaly free
i don't know if you can install only the driver
i never tried that... :-)
0
 
mustaccioConnect With a Mentor Commented:
What you need is "IBM Data Server Driver Package" - it comes with an installer. Once the software is installed, you will need to go through a regular procedure of creating an ODBC data source using the new DB2 driver. You will need, apart from the username and password, the server hostname or IP address, DB2 port, and the database name.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
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.

All Courses

From novice to tech pro — start learning today.