ruby problem connecting to oracle using oci8

Discussion in 'Ruby' started by Dheeraj Gambhir, Jul 27, 2009.

  1. Hi,

    My code is:

    require 'dbi'



    def dataVerification()
    puts "Begin Conn!"
    ora_connect = DBI.connect("DBI:OCI8:eek:rcl;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/.
    Dheeraj Gambhir, Jul 27, 2009
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Juha Laiho
    Replies:
    0
    Views:
    525
    Juha Laiho
    Jul 30, 2003
  2. Replies:
    1
    Views:
    230
    Wilson Bilkovich
    Nov 7, 2006
  3. Jason  Vogel
    Replies:
    4
    Views:
    277
    Jason Vogel
    Nov 21, 2006
  4. Peter Bailey
    Replies:
    11
    Views:
    519
    Vetrivel Vetrivel
    Nov 30, 2009
  5. ankur srivastava

    ERR In Connecting Oracle DB using OCI8 gem

    ankur srivastava, Jun 17, 2013, in forum: Ruby
    Replies:
    1
    Views:
    231
    Simon Krahnke
    Jun 17, 2013
Loading...

Share This Page