Forum: Ruby ruby odbc

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
4bfcb18ca5298df54d8eb410244d004f?d=identicon&s=25 Uwe Kubosch (Guest)
on 2007-07-02 16:40
(Received via mailing list)
Hi all!

I am trying to use ActiveRecord migrations from Linux on an MS SQL
Server database running on windows.  I am following the instructions
given in

I have successfully set up freetds and unixODBC, and I can connect fine
using tsql and isql.

When I try connecting using ruby I get the following:

[root@pippin laptop_scripts]# irb
irb(main):001:0> require 'odbc'
=> true
irb(main):002:0> require 'dbi'
=> true
irb(main):003:0> dbh = DBI.connect('dbi:ODBC:database_name', 'username',
NoMethodError: undefined method `default_attributes' for
#<ODBC::Driver:0xb7f6ade4 @attrs={}, @name=nil>
        from /usr/lib/ruby/site_ruby/1.8/dbi.rb:420:in `connect'
        from /usr/lib/ruby/site_ruby/1.8/dbi.rb:215:in `connect'
        from (irb):3

Checking the ruby odbc documentation, the default_attributes method is
not defined, and the Driver class inherits from Object.

dbi.rb also tries to call a "connect" method on the Driver class, but
"connect" is only defined on the ODBC module, not the Driver class.

What do I need to do to be able to connect?  Any help is greatly

This topic is locked and can not be replied to.