# ActiveRecord / SQL Server / ADO

**URL:** <https://www.ruby-forum.com/t/activerecord-sql-server-ado/118434>\
**Category:** Ruby\
**Created:** [October 26, 2007, 9:59pm UTC](https://www.ruby-forum.com/t/activerecord-sql-server-ado/118434 "2007-10-26T21:59:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![moonshot](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@moonshot](https://www.ruby-forum.com/u/moonshot)\
**Post date:** [October 26, 2007, 9:59pm UTC](https://www.ruby-forum.com/t/activerecord-sql-server-ado/118434/1 "2007-10-26T21:59:15Z")

</div>

I’m trying to use ActiveRecord with SQL Server and ADO in a regular ruby  
script, but can’t get it working. I’ve seen a bunch of examples but  
can’t get them to work.

Here’s what I’ve got:

require ‘rubygems’  
require ‘active\_record’

class TestMO \< ActiveRecord::Base

```
ActiveRecord::Base.establish_connection(
    :adapter => "sqlserver",
    :mode => "ado",
    :database => "mydb",
    :username => "user",
    :password => "pass"
)

set_table_name "test_mo"

```

end

I’ve got the ADO.rb in the right place I believe.

Here’s the error I’m getting:

custom\_require.rb:27:in `gem\_original\_require’: no such file to load

---

<div class="post-metadata">

**Author:** ![moonshot](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@moonshot](https://www.ruby-forum.com/u/moonshot)\
**Post date:** [October 27, 2007, 5:55am UTC](https://www.ruby-forum.com/t/activerecord-sql-server-ado/118434/2 "2007-10-27T05:55:37Z")

</div>

On Oct 26, 2:59 pm, Jayson B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> I’ve got the ADO.rb in the right place I believe.
> 
> Here’s the error I’m getting:
> 
> ## custom\_require.rb:27:in `gem\_original\_require’: no such file to load
> 
> Posted viahttp://www.ruby-forum.com/.

I believe you need to use ‘gem’ or ‘require\_gem’ for active\_record.

---

<div class="post-metadata">

**Author:** ![moonshot](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@moonshot](https://www.ruby-forum.com/u/moonshot)\
**Post date:** [October 27, 2007, 11:34am UTC](https://www.ruby-forum.com/t/activerecord-sql-server-ado/118434/3 "2007-10-27T11:34:30Z")

</div>

removed\_email\_address@domain.invalid wrote:

> I believe you need to use ‘gem’ or ‘require\_gem’ for active\_record.

No, gem only sets the version of a later required gem and require\_gem is  
deprecated.

irb(main):001:0\> require “rubygems”  
=\> true  
irb(main):002:0\> require “active\_record”  
=\> true

---

<div class="post-metadata">

**Author:** ![moonshot](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@moonshot](https://www.ruby-forum.com/u/moonshot)\
**Post date:** [October 27, 2007, 6:10am UTC](https://www.ruby-forum.com/t/activerecord-sql-server-ado/118434/4 "2007-10-27T06:10:48Z")

</div>

On Oct 26, 2:59 pm, Jayson B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> I’ve got the ADO.rb in the right place I believe.
> 
> Here’s the error I’m getting:
> 
> ## custom\_require.rb:27:in `gem\_original\_require’: no such file to load
> 
> Posted viahttp://www.ruby-forum.com/.

I believe you need to use ‘gem’ or ‘require\_gem’ for active\_record.

---

<div class="post-metadata">

**Author:** ![moonshot](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@moonshot](https://www.ruby-forum.com/u/moonshot)\
**Post date:** [October 27, 2007, 11:35am UTC](https://www.ruby-forum.com/t/activerecord-sql-server-ado/118434/5 "2007-10-27T11:35:40Z")

</div>

Jayson B. wrote:

> I’m trying to use ActiveRecord with SQL Server and ADO in a regular ruby  
> script, but can’t get it working. I’ve seen a bunch of examples but  
> can’t get them to work.
> 
> Here’s what I’ve got:
> 
> require ‘rubygems’  
> require ‘active\_record’

> Here’s the error I’m getting:
> 
> custom\_require.rb:27:in `gem\_original\_require’: no such file to load

Is this the exact line?

I got

irb(main):003:0\> require “some”  
MissingSourceFile: no such file to load – some  
from  
/usr/local/lib/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`gem\_original\_require’

Which version of rubygems are you using?