# ODBC query

**URL:** <https://www.ruby-forum.com/t/odbc-query/189860>\
**Category:** Ruby\
**Created:** [June 9, 2010, 1:20am UTC](https://www.ruby-forum.com/t/odbc-query/189860 "2010-06-09T01:20:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![alphanumericone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/ebca7d/32.png) [@alphanumericone](https://www.ruby-forum.com/u/alphanumericone)\
**Post date:** [June 9, 2010, 1:20am UTC](https://www.ruby-forum.com/t/odbc-query/189860/1 "2010-06-09T01:20:42Z")

</div>

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?