ODBC query

Discussion in 'Ruby' started by Brian George, Jun 9, 2010.

  1. Brian George

    Brian George Guest

    I'm attempting to connect to a database via ODBC connection.
    I have the following gems installed:
    dbi-0.4.3
    dbd-odbc-0.2.5

    I'm attempting to connect to an odbc connection with the name
    'IRVQA-AUTO2'

    irb(main):001:0> require 'DBI'
    C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/lib/DBI.rb:93:
    warning: already initialized constant VERSION
    C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/lib/DBI.rb:96:
    warning: already initialized constant API_VERSION
    C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/lib/DBI.rb:100
    : warning: already initialized constant DEFAULT_TRACE_MODE
    C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/lib/DBI.rb:101
    : warning: already initialized constant DEFAULT_TRACE_OUTPUT
    => []
    irb(main):002:0> conn =
    DBI.connect("DBI:ODBC:IRVQAAUTO2","poweruser","nexaqa")
    DBI::InterfaceError: Unable to load driver 'ODBC' (underlying error:
    uninitializ
    ed constant DBI::DBD::ODBC)
    from C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/l
    ib/DBI.rb:300:in `load_driver'
    from C:/Ruby187/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    from C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/l
    ib/DBI.rb:242:in `load_driver'
    from C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/l
    ib/DBI.rb:160:in `_get_full_driver'
    from C:/Documents and
    Settings/bgeorge/.bundle/ruby/1.8/gems/dbi-0.4.3/l
    ib/DBI.rb:145:in `connect'
    from (irb):2


    Any ideas what my downfall may be?
    --
    Posted via http://www.ruby-forum.com/.
    Brian George, Jun 9, 2010
    #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. Wolfgang Kaml
    Replies:
    10
    Views:
    726
    Wolfgang Kaml
    Feb 3, 2004
  2. =?Utf-8?B?TmFiaW4=?=
    Replies:
    0
    Views:
    503
    =?Utf-8?B?TmFiaW4=?=
    Oct 11, 2006
  3. asit

    insert query in ODBC

    asit, Jul 18, 2009, in forum: Java
    Replies:
    4
    Views:
    739
    Roedy Green
    Jul 18, 2009
  4. Wolfgang Kaml
    Replies:
    11
    Views:
    467
    Cowboy \(Gregory A. Beamer\)
    Jan 23, 2004
  5. Wes Gamble
    Replies:
    1
    Views:
    152
    Gerardo Santana Gómez Garrido
    Apr 5, 2006
Loading...

Share This Page