Ubuntu + MS SQL Server + Stored Procs

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?

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

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