toamitkumar's Code Blog

Ruby, Rails, RubyMotion, Chef, Puppet, Play and others. Opinions expressed here are my own and do not reflect those of my employer.

Connecting to SQL Server From Linux/Suse/Snow Leopard

| Comments

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