Ubuntu + MS SQL Server + Stored Procs

Rails
1

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?

2

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

3

Hi Stephan,
Does this setup require ruby dbi?

On Feb 21, 11:22 am, Stephan W. [email protected]

4

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