Integrating Watir with SQL Server 2000

I don't have experience with Ruby and SQL Server together,
however I
imagine the people who do have such experience will be more
willing to
respond if you tell them about what you have tried and the
errors/issues encountered.  Thanks.

Cheers,
Daniel.


On 20/06/06, jet iba˙fffff1ez <lovo_empireyahoo.com> wrote:
>
> I'm having a problem with one of the projects i'm
handling right now. I was
> asked to create automation scripts using watir that
could also access SQL
> Server 2000.
> Can anybody help me out with this???
> I've read some of the posts here regarding database
connectivity but it
> doesn't seem to work and I can't figure out how I can
make them to work.
> Please help me out guys. Thanks in advance...
>
>  Send instant messages to your online friends http://uk.messenger.yah
oo.com
> _______________________________________________
> Wtr-general mailing list
> Wtr-generalrubyforge.org
> htt
p://rubyforge.org/mailman/listinfo/wtr-general
>
>
_______________________________________________
Wtr-general mailing list
Wtr-generalrubyforge.org
htt
p://rubyforge.org/mailman/listinfo/wtr-general

require 'odbc'
c = ODBC::connect('odbc database name, 'user',
'password')
data = c.run("SELECT * FROM FOO")
data.each do |record|
puts record
end
c.disconnect

Post the code you tried with, please.
-Chris

On 6/19/06, jet iba˙fffff1ez <lovo_empireyahoo.com> wrote:
>
> I'm having a problem with one of the projects i'm
handling right now. I was
> asked to create automation scripts using watir that
could also access SQL
> Server 2000.
> Can anybody help me out with this???
> I've read some of the posts here regarding database
connectivity but it
> doesn't seem to work and I can't figure out how I can
make them to work.
> Please help me out guys. Thanks in advance...
>
>  Send instant messages to your online friends http://uk.messenger.yah
oo.com
> _______________________________________________
> Wtr-general mailing list
> Wtr-generalrubyforge.org
> htt
p://rubyforge.org/mailman/listinfo/wtr-general
>
>
_______________________________________________
Wtr-general mailing list
Wtr-generalrubyforge.org
htt
p://rubyforge.org/mailman/listinfo/wtr-general

Hi all,

I'm trying to use cookiemanager to delete data between
test iterations but my paths contain spaces. I don't
have a problem getting the paths using
getSpecialFolderLocation but I get an error when I use
them with deleteSpecialFolderContents to try to delete
my cookies or my cache. 

As far as I can tell, this doesn't have anything to do
with Watir but I was hoping that someone here would
know since it's probably Windows-related.

Thanks

John

c:/ruby/lib/ruby/site_ruby/1.8/watir/cookiemanager.rb:6:in
`visit': uninitialized constant Dir::Find (NameError)
        from
c:/ruby/lib/ruby/site_ruby/1.8/watir/cookiemanager.rb:14:in
`rm_rf'

       from
c:/ruby/lib/ruby/site_ruby/1.8/watir/cookiemanager.rb:48:in
`delete
SpecialFolderContents'
        from C:/thread_testing/cookiemgr.rb:15 





__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection
around 
http://mail.yahoo.com 
_______________________________________________
Wtr-general mailing list
Wtr-generalrubyforge.org
htt
p://rubyforge.org/mailman/listinfo/wtr-general

>I'm trying to use cookiemanager to delete data between
test iterations but
my paths contain spaces.

What does your /code/ contain?

---Michael B.


_______________________________________________
Wtr-general mailing list
Wtr-generalrubyforge.org
htt
p://rubyforge.org/mailman/listinfo/wtr-general

<<Your error message does not suggest to me that the
spaces in your path names is the problem.>>

I think you're right. Although I'm not sure what to do
about it yet. I did find something here:

http://rubyforge.org/pipermail/wtr-general/2
005-November/004055.html

BTW, appreciate the previous help from you and the
others re: multi-instance. At this point, I think most
of my problem was a combination of IE and the app I
was writing tests for (so I'm now looking for some
automated way to clear the cache and remove all
cookies before each iteration). 

I basically decided to plow ahead and try to convince
my co-workers to adopt Watir regardless of whether or
not this particular problem gets solved. I'm hooked
and the response from others has been really good so
far.  

John



--- Bret Pettichord <bretpettichord.com> wrote:

> Your error message does not suggest to me that the
> spaces in your path names
> is the problem.
> 
> Bret
> 
> On 6/20/06, John Fitisoff <jfitisoffyahoo.com>
> wrote:
> >
> > Hi all,
> >
> > I'm trying to use cookiemanager to delete data
> between
> > test iterations but my paths contain spaces. I
> don't
> > have a problem getting the paths using
> > getSpecialFolderLocation but I get an error when I
> use
> > them with deleteSpecialFolderContents to try to
> delete
> > my cookies or my cache.
> >
> > As far as I can tell, this doesn't have anything
> to do
> > with Watir but I was hoping that someone here
> would
> > know since it's probably Windows-related.
> >
> > Thanks
> >
> > John
> >
> >
>
c:/ruby/lib/ruby/site_ruby/1.8/watir/cookiemanager.rb:6:in
> > `visit': uninitialized constant Dir::Find
> (NameError)
> >         from
> >
>
c:/ruby/lib/ruby/site_ruby/1.8/watir/cookiemanager.rb:14:in
> > `rm_rf'
> >
> >        from
> >
>
c:/ruby/lib/ruby/site_ruby/1.8/watir/cookiemanager.rb:48:in
> > `delete
> > SpecialFolderContents'
> >         from C:/thread_testing/cookiemgr.rb:15
> >
> >
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> > _______________________________________________
> > Wtr-general mailing list
> > Wtr-generalrubyforge.org
> > htt
p://rubyforge.org/mailman/listinfo/wtr-general
> >
> > _______________________________________________
> Wtr-general mailing list
> Wtr-generalrubyforge.org
> htt
p://rubyforge.org/mailman/listinfo/wtr-general


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection
around 
http://mail.yahoo.com 
_______________________________________________
Wtr-general mailing list
Wtr-generalrubyforge.org
htt
p://rubyforge.org/mailman/listinfo/wtr-general

NP. I'll take a look at it and try to figure out why
it's failing.

Thanks

John

--- Bret Pettichord <bretpettichord.com> wrote:

> On 6/21/06, John Fitisoff <jfitisoffyahoo.com>
> wrote:
> >
> > I basically decided to plow ahead and try to
> convince
> > my co-workers to adopt Watir regardless of whether
> or
> > not this particular problem gets solved. I'm
> hooked
> > and the response from others has been really good
> so
> > far.
> 
> 
> The cookie manager was contributed by Ati Ozgur and
> isn't really supported.
> It doesn't have any tests and no one is fixing bugs
> for it.
> 
> Bret
> > _______________________________________________
> Wtr-general mailing list
> Wtr-generalrubyforge.org
> htt
p://rubyforge.org/mailman/listinfo/wtr-general


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection
around 
http://mail.yahoo.com 
_______________________________________________
Wtr-general mailing list
Wtr-generalrubyforge.org
htt
p://rubyforge.org/mailman/listinfo/wtr-general