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