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.
LVL 3
servicegroupAsked:
Who is Participating?
 
diablocuteConnect With a Mentor Commented:
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.
0
 
granbajoCommented:
Do you want the driver on the AS/400 directly or are you connecting from Linux or Windows or the likes.
0
 
armoghanCommented:
for direct access
com.ibm.as400.access.AS400JDBCDriver
are the best drivers
0
 
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.
0
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.

All Courses

From novice to tech pro — start learning today.