hi. will u plz tell me on which server u r working.sql server 2000,or 2005.bcoz i have done same with smo. . On 23 Jul 2011 01:59, "AMXStephen" <[email protected]> wrote: > 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]
-- 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]
