# SQL server

**URL:** <https://www.ruby-forum.com/t/sql-server/130100>\
**Category:** Ruby\
**Created:** [February 25, 2008, 12:06pm UTC](https://www.ruby-forum.com/t/sql-server/130100 "2008-02-25T12:06:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![LegioFox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/71e660/32.png) [@LegioFox](https://www.ruby-forum.com/u/LegioFox)\
**Post date:** [February 25, 2008, 12:06pm UTC](https://www.ruby-forum.com/t/sql-server/130100/1 "2008-02-25T12:06:17Z")

</div>

Hello all :

How connect from ruby to Microsoft SQL Server Express edition?

Thanks

---

<div class="post-metadata">

**Author:** ![LegioFox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/71e660/32.png) [@LegioFox](https://www.ruby-forum.com/u/LegioFox)\
**Post date:** [February 25, 2008, 8:45pm UTC](https://www.ruby-forum.com/t/sql-server/130100/2 "2008-02-25T20:45:55Z")

</div>

Maybe this will get you started:  
[http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServer](http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServer)

---

<div class="post-metadata">

**Author:** ![LegioFox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/71e660/32.png) [@LegioFox](https://www.ruby-forum.com/u/LegioFox)\
**Post date:** [February 26, 2008, 3:42am UTC](https://www.ruby-forum.com/t/sql-server/130100/3 "2008-02-26T03:42:39Z")

</div>

LegioFox wrote:

> Hello all :
> 
> How connect from ruby to Microsoft SQL Server Express edition?
> 
> Thanks

In addition to ActiveRecord (already mentioned here), you can use  
win32ole and ADO. Here’s an example tested with SQL Server 2000:

> **[Ruby, ADO, and SQLServer](http://rubyonwindows.blogspot.com/2007/03/ruby-ado-and-sqlserver.html)**
>
> Ruby and ActiveX Data Objects (ADO) make working with Microsoft SQL Server databases simple. Here's a simple example of a class that manages...

David

> **[Ruby on Windows](http://rubyonwindows.blogspot.com)**
>
> On using the Ruby programming language on the Microsoft Windows platform

---

<div class="post-metadata">

**Author:** ![LegioFox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/71e660/32.png) [@LegioFox](https://www.ruby-forum.com/u/LegioFox)\
**Post date:** [February 25, 2008, 8:56pm UTC](https://www.ruby-forum.com/t/sql-server/130100/4 "2008-02-25T20:56:02Z")

</div>

El lun, 25 de feb de 2008, a las 08:05:02 +0900, LegioFox dijo:

> Hello all :
> 
> How connect from ruby to Microsoft SQL Server Express edition?  
> You can use Active Record

[http://api.rubyonrails.org/](http://api.rubyonrails.org/)

> Thanks

–  
Gastón Ramos

“I always thought Smalltalk would beat Java, I just didn’t know it would  
be  
called ‘Ruby’ when it did.”

– Kent Beck

GNU/Linux Counter user #450312

> **[Gastón Ramos](https://gastonramos.wordpress.com/)**
>
> "La mayoría de las gaviotas no se molesta en aprender sino las normas de vuelo más elementales: como ir y volver entre playa y comida. Para la mayoría de las gaviotas, no es volar lo que impor…

---

<div class="post-metadata">

**Author:** ![LegioFox](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/71e660/32.png) [@LegioFox](https://www.ruby-forum.com/u/LegioFox)\
**Post date:** [February 27, 2008, 9:20pm UTC](https://www.ruby-forum.com/t/sql-server/130100/5 "2008-02-27T21:20:50Z")

</div>

On Mon, 25 Feb 2008 12:02:30 +0100  
“LegioFox” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Hello all :
> 
> How connect from ruby to Microsoft SQL Server Express edition?

Also, it should be possible to use sequel:

[http://sequel.rubyforge.org/files/sequel/README.html](http://sequel.rubyforge.org/files/sequel/README.html)

It has ADO connector (should work if you work under windows).

Vlad