ruby access database_Ruby_编程开发_程序员俱乐部

引用
http://rubyforge.org/projects/ruby-dbi/
http://blog.csdn.net/ruby_cn/article/details/174293
http://rubygems.org/search?utf8=%E2%9C%93&query=dbd


访问 sql by ADO

require "dbi" 
require "win32ole" 

dbh=DBI.connect("DBI:ADO:Provider=SQLOLEDB.1;Data Source=.;Initial Catalog=pubs;User Id=sa;Password=root;")
dbh.execute('select * from ...')
dbh.commit
dbh.disconnect

连接 odbc

DBI.connect('dbi:ODBC:你的odbc库名','USERNAME','PASSWORD')