1require 'win32ole'
2db = WIN32OLE.new('ADODB.Connection')
3db.connectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.;"
4ev = WIN32OLE_EVENT.new(db)
5ev.on_event('WillConnect') {|*args|
6  foo
7}
8db.open
9WIN32OLE_EVENT.message_loop
10