ruby problem connecting to oracle using oci8
 

Hi,

My code is:

require 'dbi'



def dataVerification()
puts "Begin Conn!"
ora_connect = DBI.connect("DBI:OCI8:orcl;Data
Source=mlbd;UserId=mlbread;Password=mlbread")
oracleAccountInfoValues = getDBValue(ora_connect, "select invoice_id
from bam_order.ec_invoice where order_id =139920")
ora_connect.disconnect
ora_Id = oracleAccountInfoValues[0]
puts ora_Id

end
dataVerification()


When i run this, it gives me :

C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:329:in `load_driver': Unable to
load drive
r 'OCI8' (DBI::InterfaceError)
from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in
`_get_full_driver'
from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:213:in `connect'
from testcon.rb:8:in `dataVerification'
from testcon.rb:15

I am using:
-Ruby 1.8.6
-Oracle 9i Enterprise Management

Please let me know if any body have any idea that why this error is
coming?

Regards
D G
--
Posted via http://www.ruby-forum.com/.