From: andrew_queisser@... (andrew queisser)
Date: 2002-01-23T09:12:53+09:00
Subject: problems with ruby/odbc

I downloaded Ruby ODBC and tried the following program:

require 'odbc'

$c = ODBC.connect("pelewax")
$q = $c.prepare("select pn_id,fx_id,pn_thatch_dm from
ptmgr.pele_wax_fid_link_data where pn_id>'0002001001376200' and
pn_id<'0002001001376300'")
$q.execute
print q.fetch
$q.close
$c.disconnect

I get the following error:

F:\rubystuff\odbctest.rb:3: uninitialized constant ODBC(NameError)

    from F:\rubystuff\odbctest.rb:3
    from F:\rubystuff\odbctest.rb:0


I'm using rubywin with ruby 1.6. I downloaded the MSVC DLL odbc.so and
copied it to the right directory. I made sure ruby actually finds the
DLL and it seems to. Not sure where to go from here, any help
appreciated.

Thanks,
Andrew Queisser