Ken Collins from EngineYard released TinyTds, a ruby gem that uses dblib to connect to MS SQL server. It has no hassles of managing ODBC connection. Read the blog for detailed explanation.

Before TinyTDS:

The steps for setting libraries to connect to MS SQL on *nix environment. Follow the steps religiously to succeed.

Enter TinyTDS:

TinyTDS helps ODBC-less connection which means no pain of installing all the ODBC libraries. It took a min to set-up the connection using the steps.

Goodies: Steps on Mac OSx Snow Leopard