require 'active_record'
require 'tiny_tds'

ActiveRecord::Base.establish_connection(
  :host => "ltwpeter-vm-w7",
  :adapter => "sqlserver",
  :username => "aw_web",
  :password => "aw_web8245",
  :database => "AdventureWorks",
  :timeout => 5000 # blocking also occurs w/ :timeout => 5
)
SQL = ActiveRecord::Base
start_time = nil
begin
  start_time = Time.now
  puts "Starting ActiveRecord/SqlServer request"
  rows = SQL.connection.select_all("select count(column_name) as 'normal_count' from information_schema.columns")
  puts rows.inspect

  puts "Now pausing VirtualBox VM... "
  puts %x/ VBoxManage controlvm "Windows 7" pause /
  sleep 2
  puts "Start time #{start_time}"
  puts "Check for active Connection: #{SQL.connection.active?} "
  puts "Then execute the request again with TinyTDS timeout ..."
  rows = SQL.connection.select_all("select count(column_name) as 'timeout_count' from information_schema.columns")
  puts rows.inspect

rescue Timeout::Error => time_e
  puts time_e.inspect
rescue Errno::ETIMEDOUT => etimeout
  puts etimeout.inspect
rescue Exception => e
  puts e.inspect
ensure
  puts "End  time #{Time.now} "
  puts "Total time for SQL request: #{start_time.nil? ? "error" : Time.now - start_time} "
  sleep 1
  puts "Now resuming VirtualBox VM... "
  puts %x/ VBoxManage controlvm "Windows 7" resume /
end
# # Total time for reqeust to 192.168.12.12: 74.629005