Ruby DBI

[Starke]

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?

 

[Damjan Rems]

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

 

[Brian Candler]

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.

 

[Starke]

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...

 

[Brian Candler]

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...

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.