Hello folks, We are using SQL Server and I am having trouble connecting to the database here using ActiveRecord. So far I have the script working for the E1 side of it, clicking buttons, entering fields, and using it as we need it to for our tests. We now need it to make calls to the database.
So far I have isolated my code for what should be connecting to the database and checking to see if it will connect at all without any queries. What I cannot discover on Google or any of the manuals I have looked in is the correct ':database' and ':host' parameters for a JDE server. What I have written is my best guess after searching through SQL Server, and everything I can find on the subject through Google. <~~~~~~~~~START CODE~~~~~~~~~~~~~> require 'rubygems' require 'watir' gem 'activerecord' require 'active_record' ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :dsn => "E900", :host => "\\IDAUTILDB\\E900", :database => "JDE_DEVELOPMENT", #:username => "*******" #:password => "*******" ) puts ActiveRecord::Base.connected? <~~~~~~~~END CODE~~~~~~~~> This is consistently passing back false, I was hoping that it would return true if it is successfully connecting (as I have no other way to know if this portion is working correctly). Thanks in advance! -- Before posting, please read http://watir.com/support. In short: search before you ask, be nice. [email protected] http://groups.google.com/group/watir-general [email protected]
