# Ubuntu + MS SQL Server + Stored Procs

**URL:** <https://www.ruby-forum.com/t/ubuntu-ms-sql-server-stored-procs/129800>\
**Category:** Rails\
**Created:** [February 21, 2008, 5:51pm UTC](https://www.ruby-forum.com/t/ubuntu-ms-sql-server-stored-procs/129800 "2008-02-21T17:51:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![uncle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/e5b9ba/32.png) [@uncle](https://www.ruby-forum.com/u/uncle)\
**Post date:** [February 21, 2008, 5:51pm UTC](https://www.ruby-forum.com/t/ubuntu-ms-sql-server-stored-procs/129800/1 "2008-02-21T17:51:06Z")

</div>

After searching and futzing for quite a while I have not found any  
consensus on the right/best way to have rails on Ubuntu (linux) talked  
to SQL Server.

It seems like there is an ODBC path and an ADO path

- it is not clear the ADO path works on a linux client
- some say freeTDS is dead
- unixODBC or iODBC

Anyone out there know the right path thru all this?

---

<div class="post-metadata">

**Author:** ![uncle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/e5b9ba/32.png) [@uncle](https://www.ruby-forum.com/u/uncle)\
**Post date:** [February 21, 2008, 6:22pm UTC](https://www.ruby-forum.com/t/ubuntu-ms-sql-server-stored-procs/129800/2 "2008-02-21T18:22:59Z")

</div>

uncle wrote:

> After searching and futzing for quite a while I have not found any  
> consensus on the right/best way to have rails on Ubuntu (linux) talked  
> to SQL Server.
> 
> It seems like there is an ODBC path and an ADO path
> 
> - it is not clear the ADO path works on a linux client
> - some say freeTDS is dead
> - unixODBC or iODBC
> 
> Anyone out there know the right path thru all this?

Been using freetds + ruby-odbc-0.997 + libiodbc / Ubuntu / SQLserver in  
production environment for more than a year

Stephan

---

<div class="post-metadata">

**Author:** ![uncle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/e5b9ba/32.png) [@uncle](https://www.ruby-forum.com/u/uncle)\
**Post date:** [February 21, 2008, 7:41pm UTC](https://www.ruby-forum.com/t/ubuntu-ms-sql-server-stored-procs/129800/3 "2008-02-21T19:41:38Z")

</div>

Hi Stephan,  
Does this setup require ruby dbi?

On Feb 21, 11:22 am, Stephan W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![uncle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/e5b9ba/32.png) [@uncle](https://www.ruby-forum.com/u/uncle)\
**Post date:** [February 21, 2008, 8:55pm UTC](https://www.ruby-forum.com/t/ubuntu-ms-sql-server-stored-procs/129800/4 "2008-02-21T20:55:23Z")

</div>

uncle wrote:

> Hi Stephan,  
> Does this setup require ruby dbi?

Using  
[http://rubyforge.org/frs/download.php/655/ruby-dbi-all-0.0.23.tar.gz](http://rubyforge.org/frs/download.php/655/ruby-dbi-all-0.0.23.tar.gz)