From: Shashank Date <sdate@...>
Date: 2004-05-20T20:48:48+09:00
Subject: Re: ODBC connection string for MS-Access

Hello Michael,

"Michael Neumann" <mneumann@ntecs.de> wrote in message
> It's already fixed in CVS, I just need to make a release.
>
> Regards,
>
>   Michael

It is still not working for me:
--------------------------------------------------------------------
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>cd atest

C:\atest>ruby -v tst_dbi_odbc.rb
ruby 1.8.1 (2003-12-25) [i386-mswin32]
"0.0.18"
c:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:78:in `connect': S1090 (0)
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
(DBI::DatabaseError)
        from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:550:in `connect'
        from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:367:in `connect'
        from tst_dbi_odbc.rb:5

** After installing the newly released version:

C:\atest>ruby -v tst_dbi_odbc.rb
ruby 1.8.1 (2003-12-25) [i386-mswin32]
c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:318: warning: method redefined;
discarding old fraction
"0.0.21"
c:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:78:in `connect': S1090 (0)
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
(DBI::DatabaseError)
        from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:575:in `connect'
        from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:375:in `connect'
        from tst_dbi_odbc.rb:5

C:\atest>type tst_dbi_odbc.rb
require 'dbi'

p DBI::VERSION

dbh = DBI.connect("DBI:ODBC:driver=Microsoft Access Driver
(*.mdb);dbq=C:/mrmat4")
p dbh.tables

dbh.disconnect

C:\atest>ruby -v tst_odbc3.rb
ruby 1.8.1 (2003-12-25) [i386-mswin32]
["C:/mrmat4", nil, "MSysAccessObjects", "SYSTEM TABLE", nil]

C:\atest>type tst_odbc3.rb
require 'odbc'
include ODBC

drv = Driver.new
drv.name = 'Driver1'
drv.attrs['driver'] = 'Microsoft Access Driver (*.mdb)'
drv.attrs['dbq'] = 'C:/mrmat4'
dbh = Database.new.drvconnect(drv)
p dbh.tables.fetch_all[0]

dbh.disconnect

C:\atest>