• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 877
  • Last Modified:

AS400 JDBC Access

Does anyone know of a good driver for JDBC AS400 access?
Currently I am running V5R3 on the AS400 box.

The jt400.jar driver is very slow.
I try to use the beta stinger, I cannot figure out how to use it.
1 Solution
Do you want the driver on the AS/400 directly or are you connecting from Linux or Windows or the likes.
for direct access
are the best drivers
servicegroupAuthor Commented:
I am connecting from windows.

the direct access driver for jdbc is sooooo much slower than the ODBC driver provided from microsoft. I am currently using it.

I did some reasearch on the some of the drivers provided by 3rd parties

DataDirect does not support V5R3(currently), Also I couldn't get the stinger(the ibm beta program) to work.

So, the real question is does anyone know how to setup the stinger in JDBC, OR know a better driver than direct access.
Hi, there
There are couple of 3rd party drivers you could try out:
Hit ODBC, Hit OLEDB or HIT JDBC from HitSW.COM. They have just added V5R3 support.
I have not tried them out yet, so I would appreciate you'd let me if it works out okay.
Lansa.com also offers ODBC driver for OS400 with V5R3 support.
Good luck.
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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