watir连接SQL Server2005

a) http://rubyforge.org/projects/ruby-dbi/下载dbi-0.2.2.zip

 51Testing软件测试网!e]$KF0H9A

b)解压缩到某目录，然后到该目录下执行2条cmd命令51Testing软件测试网l1~O5r+L}
me7zH

 51Testing软件测试网ib9b
P2U3iQ

   ruby setup.rb config

   ruby setup.rb install51Testing软件测试网
c_+s|:Mz4Y

 51Testing软件测试网$T`B5S"q

c)从lib\dbd复制ADO.rb到ruby的安装目录<Drive>:\<Ruby Dir>\lib\ruby\site_ruby\1.8\DBD\ADO ADO文件夹要自己建51Testing软件测试网$xc)_M'us$h

d )测试代码：

 51Testing软件测试网i-s+F#y(vCNR^!m

require "dbi"51Testing软件测试网cE]aV H1X

dbh=DBI.connect("DBI:ADO:Provider=SQLOLEDB;Connect Timeout=5;Data Source=192.168.1.252;Initial Catalog=Leggat;User ID=autodata;Password=autodatapassword")51Testing软件测试网&]Z-W~__Z

sth=dbh.prepare("select username from dbo.LeggatSaler")

sth.execute

while row=sth.fetch do

p row

end

e）运行，就能看到LeggatSaler表中的数据被读出来了51Testing软件测试网\+_ZX3X#d%{
ho M

 51Testing软件测试网:W Ys2MT7o:d/g