Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 18200
  • Last Modified:

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

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
Paula DiTallo
Asked:
Paula DiTallo
  • 4
  • 2
1 Solution
 
momi_sabagCommented:
i would google for
ibm db2 iseries client download

0
 
Paula DiTalloIntegration developerAuthor Commented:
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
 
tliottaCommented:
...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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
Paula DiTalloIntegration developerAuthor Commented:
...@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
 
tliottaCommented:
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
 
Paula DiTalloIntegration developerAuthor Commented:

@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
 
Paula DiTalloIntegration developerAuthor Commented:
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now