# New rubier and sql

**URL:** <https://www.ruby-forum.com/t/new-rubier-and-sql/176862>\
**Category:** Ruby\
**Created:** [October 7, 2009, 6:49am UTC](https://www.ruby-forum.com/t/new-rubier-and-sql/176862 "2009-10-07T06:49:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gmichelson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/db5fbb/32.png) [@gmichelson](https://www.ruby-forum.com/u/gmichelson)\
**Post date:** [October 7, 2009, 6:49am UTC](https://www.ruby-forum.com/t/new-rubier-and-sql/176862/1 "2009-10-07T06:49:19Z")

</div>

Hi everyone,

Iv inherited some ruby code that talks to a sql db and iv never used  
ruby before.

Ive tried to poke around to understand where the error below is coming  
from but to no result.

```auto
C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:264:in `initialize': wrong number
of arguments (1 for 2) (ArgumentError)
        from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:264:in `exception'
        from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:264:in `raise'
        from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:264:in `load_driver'
        from C:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
        from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:242:in `load_driver'
        from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:160:in
`_get_full_driver'
        from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:145:in `connect'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.2.21/lib/active_record/connection_adapters/sqlserver_adapter.rb:775:in
`connect'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.2.21/lib/active_record/connection_adapters/sqlserver_adapter.rb:211:in
`initialize'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.2.21/lib/active_record/connection_adapters/sqlserver_adapter.rb:26:in
`new'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-2.2.21/lib/active_record/connection_adapters/sqlserver_adapter.rb:26:in
`sqlserver_connection'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
`send'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
`new_connection'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in
`checkout_new_connection'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in
`checkout'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
`loop'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
`checkout'
        from C:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in
`checkout'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in
`connection'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in
`retrieve_connection'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:in
`retrieve_connection'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:113:in
`connection'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:2934:in
`quoted_table_name'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1520:in
`find_one'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1511:in
`find_from_ids'
        from
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:590:in
`find'
        from dtr_upload.rb:72
        from dtr_upload.rb:63:in `each'
        from dtr_upload.rb:63
```

and the bit of code is

ActiveRecord::Base.establish\_connection(  
:adapter =\> “sqlserver”,  
:mode =\> “ODBC”,  
:dsn =\> “DSN”,  
:username =\> “USERNAME”,  
:password =\> “PASSWORD”  
)

Any answers or info would be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![gmichelson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/db5fbb/32.png) [@gmichelson](https://www.ruby-forum.com/u/gmichelson)\
**Post date:** [October 7, 2009, 7:14am UTC](https://www.ruby-forum.com/t/new-rubier-and-sql/176862/2 "2009-10-07T07:14:57Z")

</div>

Hi install dbi driver so that u can access i suppose.

1. Download the Ruby/DBI distribution from the Ruby/DBI web site,  
unpack and cd into the directory created by unpacking the distribution  
file. For example:

2. Install the Ruby/DBI ODBC driver:

3. To test the Ruby/DBI ODBC driver with your Easysoft ODBC data  
source, create a Ruby script named ruby-dbi-odbc-example and add these  
lines

4. Run ruby-dbi-odbc-example:

Here is the source guide.

> **[How to Connect Ruby to SQL Server from Linux and Unix](https://www.easysoft.com/developer/languages/ruby/rails.html)**
>
> With no previous Rails experience, we created a functional Rails application, using Linux as our Rails platform and SQL Server as our database backend, by running a few commands and editing a configuration file.

Thanks,  
Srikanth J

> **[Srikanth Jeeva's technical Blog](http://www.srikanthjeeva.com/)**
>
> my blog is abt wht i have learnt technically, mostly in Ruby on Rails, Javascript, node.js 
> hope this share a little bit of info & adds a bit stuff., 
> Thanks.

---

<div class="post-metadata">

**Author:** ![gmichelson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/db5fbb/32.png) [@gmichelson](https://www.ruby-forum.com/u/gmichelson)\
**Post date:** [October 7, 2009, 4:36pm UTC](https://www.ruby-forum.com/t/new-rubier-and-sql/176862/3 "2009-10-07T16:36:14Z")

</div>

George Mcrand wrote:

> Hi everyone,

> Any answers or info would be greatly appreciated.

From a quick look it appears as though your dbi gem is out of date…

try “sudo gem update”