require 'tiny_tds'
require 'csv'

print("Enter host or IP of database server: ")
dbserver = gets.chomp
print("Please enter your database username: ")
user = gets.chomp
print("Please enter your password ")
password = gets.chomp

## Connect to database
client = TinyTds::Client.new username: "#{user}", password: "#{password}", host: "#{dbserver}", port: 1433, database: 'ISO_AVM2'

if client.active?
  puts 'Connection established'
end