# How can I taalk to our AS/400?

**URL:** <https://www.ruby-forum.com/t/how-can-i-taalk-to-our-as-400/50837>\
**Category:** Rails\
**Created:** [December 21, 2005, 7:11pm UTC](https://www.ruby-forum.com/t/how-can-i-taalk-to-our-as-400/50837 "2005-12-21T19:11:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![frank](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](https://www.ruby-forum.com/u/frank)\
**Post date:** [December 21, 2005, 7:11pm UTC](https://www.ruby-forum.com/t/how-can-i-taalk-to-our-as-400/50837/1 "2005-12-21T19:11:40Z")

</div>

Hello,

I can do this in java, but want to use Rails.  
How can I connect to our AS/400?

Thanks

Frank

---

<div class="post-metadata">

**Author:** ![frank](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](https://www.ruby-forum.com/u/frank)\
**Post date:** [December 21, 2005, 7:14pm UTC](https://www.ruby-forum.com/t/how-can-i-taalk-to-our-as-400/50837/2 "2005-12-21T19:14:42Z")

</div>

On 12/21/05, Frank [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Hello,
> 
> I can do this in java, but want to use Rails.  
> How can I connect to our AS/400?

Do you mean with TN5250, or some other kind of protocol, such as  
directly to a database?

---

<div class="post-metadata">

**Author:** ![frank](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](https://www.ruby-forum.com/u/frank)\
**Post date:** [December 21, 2005, 7:41pm UTC](https://www.ruby-forum.com/t/how-can-i-taalk-to-our-as-400/50837/3 "2005-12-21T19:41:50Z")

</div>

Frank,

the only way I know of connecting to an AS/400 db is via ODBC with  
languages  
like PHP or Ruby. unfortunately, there is no generic ODBC adapter for  
Rails. You might be able to create an adapter much like the sqlserver  
adapter, which utilizes ODBC, i believe.

you CAN get ruby to talk to an AS/400. on linux, you’ll need

IBM iSeries Access driver for linux  
unixODBC  
Ruby ODBC  
Ruby DBI

[http://wiki.rubyonrails.com/rails/pages/ODBC](http://wiki.rubyonrails.com/rails/pages/ODBC)  
[http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/153403](http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/153403)

---

<div class="post-metadata">

**Author:** ![frank](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](https://www.ruby-forum.com/u/frank)\
**Post date:** [December 21, 2005, 7:54pm UTC](https://www.ruby-forum.com/t/how-can-i-taalk-to-our-as-400/50837/4 "2005-12-21T19:54:04Z")

</div>

ok, I am on Windows.  
I just wanted to do simple queries to our AS/400 database.

Frank  
----- Original Message -----  
From: Chris H.  
To: removed\_email\_address@domain.invalid  
Sent: Wednesday, December 21, 2005 1:39 PM  
Subject: Re: [Rails] How can I taalk to our AS/400?

Frank,

the only way I know of connecting to an AS/400 db is via ODBC with  
languages like PHP or Ruby. unfortunately, there is no generic ODBC  
adapter for Rails. You might be able to create an adapter much like the  
sqlserver adapter, which utilizes ODBC, i believe.

you CAN get ruby to talk to an AS/400. on linux, you’ll need

IBM iSeries Access driver for linux  
unixODBC  
Ruby ODBC  
Ruby DBI

[Peak Obsession](http://wiki.rubyonrails.com/rails/pages/ODBC)  
[http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/153403](http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/153403)

On 12/21/05, Frank [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:  
Hello,

```
I can do this in java, but want to use Rails.
How can I connect to our AS/400?

Thanks

Frank

_______________________________________________
Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails

```

* * *

* * *

Rails mailing list  
removed\_email\_address@domain.invalid  
[http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

---

<div class="post-metadata">

**Author:** ![frank](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](https://www.ruby-forum.com/u/frank)\
**Post date:** [December 21, 2005, 8:18pm UTC](https://www.ruby-forum.com/t/how-can-i-taalk-to-our-as-400/50837/5 "2005-12-21T20:18:17Z")

</div>

then you’ll want the iSeries Access for Windows driver…but you’re  
still  
stuck with the fact there is no generic ODBC adapter for rails