ruby access database

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

访问 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')