From: Dheeraj Gambhir <checktestingthings@...>
Date: 2009-07-21T23:06:56+09:00
Subject: Re: Ruby/Oracle connectivity

If i run this code to check whether i am able to connect to the Oracle 
database server or not:

ruby -r oci8 -e "OCI8.new('mlbread', 'mlbread', 'MLBD').exec('select * 
from bam_order.ec_invoice where order-id>2316027') do |r| puts r.join(' 
| '); end"

It gives me:

C:\ruby>ruby -r oci8 -e "OCI8.new('mlbread', 'mlbread', 
'MLBD').exec('select * f
rom bam_order.ec_invoice where order-id>2316027') do |r| puts r.join(' | 
'); end
"
c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:52:in `init': OCI Library 
Initialization
Error (OCIError)
        from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:52

Regards
D G

Brian Candler wrote:
> Viktor Zacek wrote:
>> If you want to use JDBC with JRuby you need the ojdbc14.jar from oracle
>> homepage.
> 
> But he also said he was running ruby 1.8.6, which is not JRuby. And he 
> explicitly gets this message:
> 
> "warning: ActiveRecord-JDBC is for use with JRuby only"
> 
> So that's the problem - following someone's instructions for JRuby when 
> you're not running JRuby :-)
> 
> I'm afraid I don't use Windows. Under Linux the gems I need are:
> 
> activerecord
> activerecord-oracle-adapter
> 
> and I also need ruby-oci8 installed - which I build from source, and 
> which needs the Oracle client libraries around (I have 
> oracle-instantclient-devel, oracle-instantclient-basiclite, 
> oracle-instantclient-sqlplus)
> 
> If you go to the ruby-oci8 homepage I expect you'll find either a 
> ready-made Windows package, or instructions for installing it under 
> Windows.
> 
> HTH,
> 
> Brian.

-- 
Posted via http://www.ruby-forum.com/.