Solved

ODBC to DB2 on AIX

Posted on 2010-08-27
11
740 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
ID: 33546604
use MS access 2010 it's will help u
0
 

Author Comment

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

Accepted Solution

by:
momi_sabag earned 334 total points
ID: 33547048
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
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 

Author Comment

by:StumpedAndGrateful
ID: 33550160
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
 
LVL 37

Assisted Solution

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

Author Comment

by:StumpedAndGrateful
ID: 33568022
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
ID: 33590021
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
ID: 34760836
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 143

Expert Comment

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

792 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