TinyTDS connection issues and return from SQL server 2008
development:
   adapter: sqlserver
   host: localhost
   database: database_name
   username: username
   password: password
   timeout: 5000

 client = TinyTds::Client.new(use the above settings)
 puts client.active?
 result = client.execute("select * from tablename")
 puts "#{result}"

true
  -1