connetc to sql server db

gistfile1.txt

require 'tiny_tds'
require 'active_record'
require 'activerecord-sqlserver-adapter'
require 'logger'


ActiveRecord::Base.pluralize_table_names = false

ActiveRecord::Base.establish_connection(
    :adapter => 'sqlserver',
    :database => 'myDB',
    :username => 'trekr5',
    :password => 'password',
    :host => 'myhost.com'
)


# class Table < ActiveRecord::Base

# 	def self.test

      query = <<-SQL
        DECLARE @FundraiserId INT
        SET @FundraiserId = 250942
        PRINT @FundraiserId
      SQL

    results = ActiveRecord::Base.connection.select_all(query)

    p results
    
    results.each do |row|
    p row
    end

When i test the connection, I get a value of -1 and when I iterate through the results, I get an empty array [] which is wrong because I should see the value of @FundraiserId which is 250942.