On Aug 6, 10:47 am, dj <[email protected]> wrote:
> Hi folks,
>
> I tried this:
>
> DB = Sequel.connect
> (:adapter=>'odbc',:driver=>'Firebird',:server=>'192.168.0.81',:uid=>"xxxxxxx",:pwd=>"xxxxxxx",:database=>"finqueries")
>
> and I get this:
>
> /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/database.rb:112:in
> `adapter_class': Could not load odbc adapter:
> (Sequel::AdapterNotFound)
> no such file to load -- odbc
> from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
> database.rb:147:in `connect'
> from /usr/lib/ruby/gems/1.8/gems/sequel-3.3.0/lib/sequel/
> core.rb:73:in `connect'
> from /home/jenko/NetBeansProjects/FinQueryAlpha/lib/
> test_sequelIB.rb:5
>
> I also tried fully qualifying the :database => value (i.e., "c:/
> finqueries/finqueries.ib"), but no help.
>
> Here's my /etc/odbc.ini:
>
> [finqueries]
> Description = Firebird
> Driver = Firebird
> Dbname = 192.168.0.81:c:/finqueries/finqueries.ib
> User = xxxxxxx
> Password = xxxxxxx
> Role =
> CharacterSet =
> ReadOnly = No
> NoWait = No
>
> I verified that the ODBC is set up properly (outside of Sequel) by
> connecting via unixodbc isql and issuing "help pricedata" (a table in
> my db), and it correctly returned all the fieldnames, etc for that
> table. It looks like my Sequel config is off, any ideas?
My only experience with the ODBC adapter is on Windows, so you are
beyond my area of expertise. Due to the way the ODBC adapter is
coded, you might want to remove all options except :adapter
and :database. You could also try
Sequel.odbc('finqueries')
# or Sequel.odbc('finqueries', :user=>'*', :password=>'*')
If that doesn't work, work with Ruby ODBC in irb and see if you can
get it to connect and return results. If you can get a working Ruby
ODBC connection, it shouldn't be hard to get it working in Sequel.
Jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
