Ruby DBI


#1

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?


#2

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


#3

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.


#4

On Mar 26, 1:14 pm, Brian C. 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…


#5

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.