Forum: Ruby on Rails Legacy database support (iSeries / as/400)

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
shawn (Guest)
on 2007-03-15 18:46
(Received via mailing list)
I would really like to incorporate Ruby in my organization, but I have
been mostly limited to Java (for the past 10 years or so) due to the
availability of mature JDBC drivers (particularly for as/400 aka i5
aka iSeries).  While Java works fine, a full J2EE implementation if
often overkill for many smaller applications.  My current web
development framework of choice is Tapestry along with Spring and

I've played with Ruby and RoR for a while now, but as far as I know
there is no real support yet for DB2/400.  I don't want to run Ruby on
the iSeries, but I do need database support.  Does RoR need to be
explicitly support DB2/400, or is it possible to use a generic ODBC
connection?  I have read for the past year or so that iSeries support
is on the way, but I haven't seen any real progress yet.  I would
appreciate any information or suggestions.
Philip N. (Guest)
on 2007-03-15 23:55
(Received via mailing list)

As you are no doubt aware, there are two ways to talk to DB2/400 from
client/server applications : via a proprietary driver (iSeries Access)
using the standard DB2 client via DB2 Connect.

If you have DB2 Connect, then you should be able to use the ibm_db2
from IBM Alphaworks.    

shawn (Guest)
on 2007-03-16 17:55
(Received via mailing list)

Yes, I'm aware of those, but comments such as this: and this:

tell me that IBM is working to unify DB2 Connect support across all of
the db2 products.  It appears full support is coming in the future,
but I was curious to know if anyone in the rails community is having
success with this at the moment.

Chris H. (Guest)
on 2007-03-16 19:07
(Received via mailing list)
we're using iSeries Access and the Rails ODBC Adapter from Openlink at

it seems to work for our purposes.
John L. (Guest)
on 2014-11-06 10:55
It is helpful. Thanks for sharing.
This topic is locked and can not be replied to.