I am working with SQL Server, but since I posted this I have had a few breakthroughs using the gem DBI and connecting to said database. If you are interested let me know as I will be documenting this thoroughly and posting it online, as I don't think anyone has done this before with JD Edwards to my knowledge.
On Jul 25, 2:21 pm, sachin marne <[email protected]> wrote: > 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 readhttp://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]
