ODBC connection : ODBC « Database « Ruby






ODBC connection


require "odbc"

DSN  = "Myodbc"
USER = "YourName"
PWD  = "123"

ODBC.connect(DSN, USER, PWD) do |dbh|
  dbh.autocommit = true
  begin
    dbh.do("DROP TABLE test")
  rescue ODBC::Error; end
  dbh.do("CREATE TABLE test (id INT, name VARCHAR(30))")
  dbh.do("INSERT INTO test VALUES (?,?)", 1, 'Michael')
  dbh.autocommit = false
  dbh.prepare("INSERT INTO test VALUES(?,?)") do |sth|
    name = "AAAAA"
    99.times {|n| sth.execute(n+2, name.succ!) }
  end
  dbh.commit
  dbh.run("SELECT COUNT(*) FROM test") do |sth|
    p sth.fetch[0]  # => 100
  end
  sql = "SELECT name FROM test WHERE id BETWEEN ? AND ?"
  sth = dbh.run(sql, 49, 50)
  sth.ignorecase = true
  sth.fetch_hash do |row|
    p row['NAME']            # => "AAABW", "AAABX"
  end
  sth.drop
end

 








Related examples in the same category