Solved

iSeries Access ODBC driver: Where do I find the latest copy for x64?

Posted on 2011-09-29
7
15,104 Views
Last Modified: 2012-05-12
Hey Techies--
I have a copy of the IBM iSeries Access kit for Windows. I'm using the IBM Data Studio plugin for Eclipse and am getting poor performing results after launching queries. On SQL statements returning a heavy load, an out and out crash on the jdbc connection occurs. I looked at the odbc, since the query execution times are in the milliseconds -- the version I have is dubbed 11.64.00.00, dated back in Oct. 2005. There has to be a more current version out there. I searched under IBM's download section-- 121 results, but nothing that fits the bill.

Where do I find a current copy of the kit, or if not the kit, at least the odbc for iSeries. If the kit and/or the iSeries odbc driver isn't the standard anymore for iSeries/DB2 connectivity from Windows (its been ahile since I've been in an i/db2 environment), please let me know what is--and where I can find it.

Thanks--
 
 
0
Comment
Question by:ditallop
  • 4
  • 2
7 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 36816861
i would google for
ibm db2 iseries client download

0
 

Author Comment

by:ditallop
ID: 36817892
I see that I didn't clarify that we're running an old as/400 box @our shop. I'm aware that the kit gets delivered with the box--I am looking to see if there have been any updates since version 11.x for the as/400 iseries access kit...and if so, where?

@momi_sabag, Google gives misleading results as it tries to bring me up to date by providing links to IBM i Access -- the latest developer/operator pack for iSeries power boxes, rather than the old as/400 version... some day our as/400 will grow up to be a big, strong i power box... but that day is not yet here!;-)
0
 
LVL 27

Expert Comment

by:tliotta
ID: 36818220
...an out and out crash on the jdbc connection occurs.

Are you needing ODBC or JDBC? A Type 4 JDBC driver is available as part of the JTOpen Toolbox for Java.

Tom
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 

Author Comment

by:ditallop
ID: 36818471
...@tliotta, both.  I'm using Eclipse/Data Studio (read: uses jdbc) to work with the data, issue queries, etc. to the iseries as/400 box, then i need the odbc connection to connect the microsoft sql server reporting server tool over to the db2. i'll take a look at t-4 under the ecl plugin
0
 
LVL 27

Accepted Solution

by:
tliotta earned 500 total points
ID: 36819064
I'm not aware of an internet download upgrade for the ODBC driver except as a byproduct of ordering an upgrade to the iSeries Access product. I don't know if your existing AS/400 is eligible for upgrade.

However, on one PC I have an ODBC driver from iSeries Access V5R4 that shows as version 11.00.09.00 and is dated 3/9/2007. Perhaps you need to download and apply a more recent service pack for your version of iSeries Access. See the IBM i Access Service packs page. Go through your Windows Start menu into the iSeries Access menu to see the iSeries Access Properties window to verify what version you have and what service pack is currently installed.

Tom
0
 

Author Comment

by:ditallop
ID: 36892094

@Tom,

Thanks for looking @ one of your PCs for a version #. Hopefully we'll get these boxes (and versions) upgraded sooner rather than later. As an aside, I posted this same question over to IBM, here's the answer given there--very similar. I'll post it here with yours in case some other members on e-e have a similiar question. Thanks again for your help!


------------------ IBM answer ---------------------------------------------------------------

plditallo, You have a couple of options:


•To install the most recent fixes for IBM i Access for Windows for your release, look here: http://www-03.ibm.com/systems/i/software/access/windows/casp.html -- note that no more service packs are planned for IBM i Access for Windows in v5r4 or v6r1.


•Better yet, you can use a newer version of IBM i Access for Windows with your v5r4 server. According to this web site: http://www-03.ibm.com/systems/i/software/access/caorder.html
...
For current 5.4 IBM i Access for Windows customers:

If you have a software maintenance contract for your IBM i, you can acquire the 7.1 IBM i Access for Windows product but keep your IBM i at 5.4 by ordering the 5722-SS1 refresh feature 6287. This feature delivers the PC installation image.
 
 
0
 

Author Closing Comment

by:ditallop
ID: 36892148
Tom,
Thanks again, I appreciate your assistance. I'm shipping you my linkedin profile--I'm always looking for talented folks in our industry to stay connected with.

http://www.linkedin.com/pub/paula-ditallo/2/867/184
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used.

766 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