# Ruby DBI

**URL:** <https://www.ruby-forum.com/t/ruby-dbi/90170>\
**Category:** Ruby\
**Created:** [March 26, 2007, 4:31pm UTC](https://www.ruby-forum.com/t/ruby-dbi/90170 "2007-03-26T16:31:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Starke](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/898d66/32.png) [@Starke](https://www.ruby-forum.com/u/Starke)\
**Post date:** [March 26, 2007, 4:31pm UTC](https://www.ruby-forum.com/t/ruby-dbi/90170/1 "2007-03-26T16:31:17Z")

</div>

I am trying to create a reporting system via rails and iSeries DB2. I  
have ruby retrieve records with Ruby DBI. Is there a way to get this  
working inside rails?

---

<div class="post-metadata">

**Author:** ![Starke](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/898d66/32.png) [@Starke](https://www.ruby-forum.com/u/Starke)\
**Post date:** [March 26, 2007, 8:12pm UTC](https://www.ruby-forum.com/t/ruby-dbi/90170/2 "2007-03-26T20:12:18Z")

</div>

Starke wrote:

> I am trying to create a reporting system via rails and iSeries DB2. I  
> have ruby retrieve records with Ruby DBI. Is there a way to get this  
> working inside rails?

I see no reason, why you couldn’t access your data with DBI inside rails  
same as without rails.

by

TheR

---

<div class="post-metadata">

**Author:** ![Starke](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/898d66/32.png) [@Starke](https://www.ruby-forum.com/u/Starke)\
**Post date:** [March 26, 2007, 8:15pm UTC](https://www.ruby-forum.com/t/ruby-dbi/90170/3 "2007-03-26T20:15:18Z")

</div>

On Mon, Mar 26, 2007 at 11:30:05PM +0900, Starke wrote:

> I am trying to create a reporting system via rails and iSeries DB2. I  
> have ruby retrieve records with Ruby DBI. Is there a way to get this  
> working inside rails?

Yes.

---

<div class="post-metadata">

**Author:** ![Starke](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/898d66/32.png) [@Starke](https://www.ruby-forum.com/u/Starke)\
**Post date:** [March 26, 2007, 8:51pm UTC](https://www.ruby-forum.com/t/ruby-dbi/90170/4 "2007-03-26T20:51:23Z")

</div>

On Mar 26, 1:14 pm, Brian C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> On Mon, Mar 26, 2007 at 11:30:05PM +0900, Starke wrote:
> 
> > I am trying to create a reporting system via rails and iSeries DB2. I  
> > have ruby retrieve records with Ruby DBI. Is there a way to get this  
> > working inside rails?
> 
> Yes.

I thought so to, but I guess Im not setting up rails correctly to use  
DBI… im just guessing but I tried to setup my database.yml file as

development:  
adapter: DBI  
dsn: a2401p6  
username: STARTCA  
password: STARTCA

But it bombs. I really cant find any documenation on using DBI within  
rails…

---

<div class="post-metadata">

**Author:** ![Starke](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/898d66/32.png) [@Starke](https://www.ruby-forum.com/u/Starke)\
**Post date:** [March 26, 2007, 9:05pm UTC](https://www.ruby-forum.com/t/ruby-dbi/90170/5 "2007-03-26T21:05:25Z")

</div>

On Tue, Mar 27, 2007 at 03:50:10AM +0900, Starke wrote:

> development:  
> adapter: DBI  
> dsn: a2401p6  
> username: STARTCA  
> password: STARTCA
> 
> But it bombs. I really cant find any documenation on using DBI within  
> rails…

Ah, I see what you mean. database.yml is for ActiveRecord. Those values  
are  
passed to ActiveRecord::Base.establish\_connection or whatever.

If you want to use DBI, I think you’ll have to open the DBI connection  
yourself.

Regards,

Brian.