WindowsでRubyでOracleで(with DBI&ADO)

Ruby

念願のWindows上のRuby経由Oracle行きの切符をゲット。やっと辿り着いたよ、ママン。

忘れないようにメモ。

require "dbi"

# connect to a datbase
ds = "ds_name"
user = "scott"
passwd = "tiger"
conn_str = "DBI:ADO:Provider=OraOLEDB.Oracle;" +
           "Data Source=#{ ds };" +
           "User Id=#{ user };" +
           "Password=#{ passwd }"
dbh = DBI.connect(conn_str)

puts "selecting..."
sth=dbh.prepare('select * from customer')
sth.execute

while row=sth.fetch do
 p row
end

dbh.disconnect

ついでに参考URLも。