Forum: Ruby Confused about Ruby database interfaces available on rubyfor

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Alan (Guest)
on 2006-05-20 02:36
Hi,

I am trying use Ruby to access to our Oracle database on our windows XP
and Linux machines.
I also prefer to use DBI interface.

I have downloaded dbi-0.1.0.tar.gz from this location:
http://rubyforge.org/frs/?group_id=234&release_id=4323

dbi-0.1.0.tar.gz doesnâ??t have the OCI8 dbd driver and the installer
doesnâ??t work. I struggled and finally managed to copy files manually and
make ODBC and ADO DBDs work on windows only.

I cannot introduce this to my client as a multiplatform scripting
solution for accessing to our database! It is a mess!!!!

From the other side, there is Ruby/OCI8 available here:
http://www.jiubao.org/ruby-oci8/
Is this something than I can combine with DBI to have the DBD::OCI8?

I apologize if I sound a little bit frustrated. I am looking for a
reliable Ruby database access solution. I have posted question here (see
http://www.ruby-forum.com/topic/64065#70882) and it seems people using
DBI just fine. I donâ??t know how come I cannot find right package to
download and use!!!

Any help would be appreciated,
Alan
Dido S. (Guest)
on 2006-05-20 20:55
(Received via mailing list)
On 5/20/06, Alan <removed_email_address@domain.invalid> wrote:
> From the other side, there is Ruby/OCI8 available here:
> http://www.jiubao.org/ruby-oci8/
> Is this something than I can combine with DBI to have the DBD::OCI8?
>

Yes.  In order to get Ruby's DBI to work with Oracle, you need to
install both Ruby-DBI and Kubo-san's Ruby-OCI8 module (which includes
the DBD driver). Note that you'll probably also need at the very least
the Oracle Instant Client [1] in order to build the OCI8 module.

> I apologize if I sound a little bit frustrated. I am looking for a
> reliable Ruby database access solution. I have posted question here (see
> http://www.ruby-forum.com/topic/64065#70882) and it seems people using
> DBI just fine. I don't know how come I cannot find right package to
> download and use!!!

Don't panic... I think this just ought to be better documented.

So the steps are:

1. Download the Instant Client libraries and *install them properly*
with the correct values for the ORACLE_HOME and LD_LIBRARY_PATH
environment variables set. Best to put these in your system
/etc/profile; if these variables aren't properly set, no program using
the instant client libraries will function correctly (this is not a
Ruby issue, but an Oracle issue)
2. Download and install Ruby-DBI
3. Download and install the Ruby-OCI8 package.

Since I have almost never programmed Ruby on Windows, and have never
written a Windows program to access an Oracle database, I'm sorry I
can't help on that end.

[1]
http://otn.oracle.com/software/tech/oci/instantcli...
This topic is locked and can not be replied to.