Solved

ODBC to DB2 on AIX

Posted on 2010-08-27
11
735 Views
Last Modified: 2012-05-10
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!!!!
0
Comment
Question by:StumpedAndGrateful
11 Comments
 

Expert Comment

by:xsamir
Comment Utility
use MS access 2010 it's will help u
0
 

Author Comment

by:StumpedAndGrateful
Comment Utility
I'm stuck with 2007.  It's a company project.
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 334 total points
Comment Utility
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
 

Author Comment

by:StumpedAndGrateful
Comment Utility
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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 37

Assisted Solution

by:momi_sabag
momi_sabag earned 334 total points
Comment Utility
did you install the db2 client? or did you download just the driver?
0
 

Author Comment

by:StumpedAndGrateful
Comment Utility
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
 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
the db2 client is totaly free
i don't know if you can install only the driver
i never tried that... :-)
0
 
LVL 8

Assisted Solution

by:mustaccio
mustaccio earned 166 total points
Comment Utility
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
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
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

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now