Sha256: 6b4e47a85eab5e42711bb4c83a9398e88c2b2139292589a0fea26f0865e58fd9
Contents?: true
Size: 1.09 KB
Versions: 14
Compression:
Stored size: 1.09 KB
Contents
class ActiveRecord::Base
class << self
def mssql_connection(config)
require "arjdbc/mssql"
config[:host] ||= "localhost"
config[:port] ||= 1433
config[:driver] ||= "net.sourceforge.jtds.jdbc.Driver"
url = "jdbc:jtds:sqlserver://#{config[:host]}:#{config[:port]}/#{config[:database]}"
# Instance is often a preferrable alternative to port when dynamic ports are used.
# If instance is specified then port is essentially ignored.
url << ";instance=#{config[:instance]}" if config[:instance]
# This will enable windows domain-based authentication and will require the JTDS native libraries be available.
url << ";domain=#{config[:domain]}" if config[:domain]
# AppName is shown in sql server as additional information against the connection.
url << ";appname=#{config[:appname]}" if config[:appname]
config[:url] ||= url
if !config[:domain]
config[:username] ||= "sa"
config[:password] ||= ""
end
jdbc_connection(config)
end
alias_method :jdbcmssql_connection, :mssql_connection
end
end
Version data entries
14 entries across 14 versions & 4 rubygems