ruby连接SQL Server数据库
上一篇 /
下一篇 2011-06-17 15:56:33
/ 个人分类:ruby+watir
http://www.cnblogs.com/nikeylee/archive/2010/06/11/1756585.html
1、在ruby官网的ruby/dbi下载dbi-0.4.3.gem和dbi-0.1.0.tar.gz点此下载
2、安装dbi-0.4.3.gem
运行 gem install dbi-0.4.3.gem
3、解压dbi-0.1.0.tar.gz,在ruby-dbi\dbi-0.1.0\dbi-0.1.0\lib\dbd找ADO.rb文件
4. 手动创建ADO文件夹,创建好之后的路径为
C:\Ruby192\lib\ruby\site_ruby\1.9.1\DBD\ADO
5. 拷贝ADO.rb文件到步骤4中创建好的文件夹下面
6. 使用下面的Ruby代码连接SQL Server Native Client, 特别注意红色的部分。
require 'dbi' class Server attr_reader :name def initialize(name,username, password, database) @server_name=name @username = username @password = password @database = database @dbh=DBI.connect("DBI:ADO:Provider=SQLNCLI;Data Source=#{name};Persist Security Info=False;User ID=#{@username};password=#{@password};Initial Catalog=#{database};") end def databases db=Array.new @dbh.select_all('SELECT name FROM master.sys.databases ORDER BY 1') do | row | db.<< Database.new(@dbh,row[0]) end db end end class Database attr_reader :name def initialize(dbh,name) @dbh=dbh @name=name end end server=Server.new("hostname","username","password","database_name") server.databases.each {|x| puts x.name}
|
收藏
举报
TAG: