# Ironruby activerecord sqlserver

**URL:** <https://www.ruby-forum.com/t/ironruby-activerecord-sqlserver/190362>\
**Category:** IronRuby\
**Created:** [June 18, 2010, 2:40pm UTC](https://www.ruby-forum.com/t/ironruby-activerecord-sqlserver/190362 "2010-06-18T14:40:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![michbukana](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@michbukana](https://www.ruby-forum.com/u/michbukana)\
**Post date:** [June 18, 2010, 2:40pm UTC](https://www.ruby-forum.com/t/ironruby-activerecord-sqlserver/190362/1 "2010-06-18T14:40:57Z")

</div>

Hi all

## When running this ruby program:

require ‘rubygems’  
require ‘active\_record’  
require ‘yaml’  
ActiveRecord::Base.establish\_connection(  
:adapter =\> ‘sqlserver’,  
:database =\> ‘xxxxx’,  
:username =\> ‘sa’,  
:password =\> ‘pass’,  
:mode =\> ‘ODBC’,  
:host =\> “MYLAPTOP\SQLSERVER”)

class User \< ActiveRecord::Base  
end  
puts User.count

* * *

## These are the local gems installed:

## actionmailer (2.3.8) actionpack (2.3.8) activerecord (2.3.8) activerecord-sqlserver-adapter (2.3.8) activeresource (2.3.8) activesupport (2.3.8) dbd-adonet (0.3.2) dbd-adonet-sqlserver (0.3.2) dbi (0.4.3) deprecated (3.0.0) rack (1.1.0) rails (2.3.8) rake (0.8.7)

## I’m receiving the following error:

WARNING: YAML.add\_builtin\_type is not implemented

C:/Program Files/IronRuby  
1.0v4/lib/ironruby/gems/1.8/gems/activesupport-2.3.8/lib/active\_support/dependencies.rb:156:in  
`require': no such file to load -- odbc (MissingSourceFile) from C:/Program Files/IronRuby 1.0v4/lib/ironruby/gems/1.8/gems/activesupport-2.3.8/lib/active_support/dependenc ies.rb:490:in`new\_constants\_in’  
from C:/Program Files/IronRuby  
1.0v4/lib/ironruby/gems/1.8/gems/activesupport-2.3.8/lib/active\_support/dependenc  
ies.rb:154:in `require’

* * *

What am I missing?

---

<div class="post-metadata">

**Author:** ![michbukana](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@michbukana](https://www.ruby-forum.com/u/michbukana)\
**Post date:** [June 18, 2010, 3:10pm UTC](https://www.ruby-forum.com/t/ironruby-activerecord-sqlserver/190362/2 "2010-06-18T15:10:40Z")

</div>

the config is wrong

[http://github.com/casualjim/irontwitter/blob/master/config/database.yml](http://github.com/casualjim/irontwitter/blob/master/config/database.yml)  
[http://github.com/casualjim/irontwitter/blob/master/config/database.yml](http://github.com/casualjim/irontwitter/blob/master/config/database.yml)  
[http://github.com/casualjim/irontwitter/blob/master/config/environment.rb](http://github.com/casualjim/irontwitter/blob/master/config/environment.rb)

[http://github.com/casualjim/irontwitter/blob/master/config/environment.rb](http://github.com/casualjim/irontwitter/blob/master/config/environment.rb)But  
I believe the official sqlserver-adapter that comes with rails has  
ironruby  
support now.  
Anyway ODBC is most likely the wrong choice. Unless you’re using MRI on  
a  
non-windows system you want to use ADONET for .NET and ADO for MRI.

## The config for the rails sqlserver gem is the same as the one I’m showing. but the gems most likely aren’t

Met vriendelijke groeten - Best regards - Salutations  
Ivan Porto C.  
Twitter: [http://twitter.com/casualjim](http://twitter.com/casualjim)  
Author of IronRuby in Action ([IronRuby in Action - Ivan Porto Carrero and Adam Burmister | Manning](http://manning.com/carrero))  
Microsoft IronRuby/C# MVP

---

<div class="post-metadata">

**Author:** ![michbukana](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@michbukana](https://www.ruby-forum.com/u/michbukana)\
**Post date:** [June 18, 2010, 3:49pm UTC](https://www.ruby-forum.com/t/ironruby-activerecord-sqlserver/190362/3 "2010-06-18T15:49:14Z")

</div>

Thank you, Thank you, Thank you  
It works now!!!

Eduardo

PS: by the way when is the ETA of your book IronRuby in action?  
Ivan Porto C. wrote:

> the config is wrong
> 
> [http://github.com/casualjim/irontwitter/blob/master/config/database.yml](http://github.com/casualjim/irontwitter/blob/master/config/database.yml)  
> [http://github.com/casualjim/irontwitter/blob/master/config/database.yml](http://github.com/casualjim/irontwitter/blob/master/config/database.yml)  
> [http://github.com/casualjim/irontwitter/blob/master/config/environment.rb](http://github.com/casualjim/irontwitter/blob/master/config/environment.rb)
> 
> [http://github.com/casualjim/irontwitter/blob/master/config/environment.rb](http://github.com/casualjim/irontwitter/blob/master/config/environment.rb)But  
> I believe the official sqlserver-adapter that comes with rails has  
> ironruby  
> support now.  
> Anyway ODBC is most likely the wrong choice. Unless you’re using MRI on  
> a  
> non-windows system you want to use ADONET for .NET and ADO for MRI.
> 
> ## The config for the rails sqlserver gem is the same as the one I’m showing. but the gems most likely aren’t
> 
> Met vriendelijke groeten - Best regards - Salutations  
> Ivan Porto C.  
> Twitter: [http://twitter.com/casualjim](http://twitter.com/casualjim)  
> Author of IronRuby in Action ([IronRuby in Action - Ivan Porto Carrero and Adam Burmister | Manning](http://manning.com/carrero))  
> Microsoft IronRuby/C# MVP