Hi Brian,
First of all, thanks a lot for replying so quickly.
I am using Oracle 9i, ruby 1.8.6 .
Till now i have tried:
require 'rubygems'
gem 'ActiveRecord-JDBC'
require 'jdbc_adapter'
require 'active_record'
require 'active_record/version'
ActiveRecord::Base.establish_connection(
:adapter => 'jdbc',
:driver => 'oracle.jdbc.driver.OracleDriver',
:url => 'jdbc
racle:thin
myhost:1521:mydb',
:username=>'mlbread',
assword=>'mlbread'
)
ActiveRecord::Base.connection.execute("SELECT * FROM
bam_order.ec_invoice")
****************************************
It gives following error:
C:\Program Files\Watir\examples>ruby oraclecon.rb
warning: ActiveRecord-JDBC is for use with JRuby only
c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`gem_original_re
quire': no such file to load -- c:/ruby/jruby-1.2.0/lib/ojdbc14.jar
(MissingSour
ceFile)
from
c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `re
quire'
from
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/active_suppo
rt/dependencies.rb:156:in `require'
from
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/active_suppo
rt/dependencies.rb:521:in `new_constants_in'
from
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/active_suppo
rt/dependencies.rb:156:in `require'
from oraclecon.rb:6
Regards
Dheeraj Gambhir