search for: rubyodbc

Hi all, I''ve got a very obscure problem. We''re trying to get Rails to talk to Filemaker. So we''ve setup an ODBC dsn and via RubyODBC we''re talking to it. Excellent. Try it under rails and rails won''t even startup, getting bus errors anytime we require ''odbc''. Environment OSX Tiger 10.4.6 Rails 1.1.2 Ruby 1.8.4 RubyODBC 0.998 via IRB: irb(main):001:0> require ''odbc'' =>...

I could not find the answer to this in a few Google searches and thought I would ask. So when are prepared statements best leveraged in ActiveRecord''s interface? I never really noticed before, but simple condition hashes or scopes do not pass down the binds so that prepared statements are leveraged. So a `Car.find(1)` would but things like `Car.where(:id => 1).first` do not. Is it a

...is, when we run the application on the production server which runs Windows, the problems remain. AFAICT, the ruby-odbc drivers are installed alongside Ruby using the One-Click Installer, which we did use. Only thing about this is, that according to the author of ruby- odbc (http://www.ch-werner.de/rubyodbc/), the latest version compiled for Win32 is 0.997, which is from 2005. And the problems we experienced disappeared somewhere between versions 0.999 and 0.9994. Does anybody know of a newer build for Win32? Thanks in advance, Daniel --~--~---------~--~----~------------~-------~--~----~ You rece...

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

I have an app that needs to retreive data through an ODBC connection on a windows platform. Has anyone done this? Would someone be able to walk me through it? or point me to the relavant docs. My searches haven''t turned up any usefull information so far. -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson

require ''dbi'' # 0.4.2 dbh = DBI.connect(''DBI:ODBC:PACS'', ''username'', ''password'') This works in IRB; in Rails it fails (taken from Rails console): DBI::InterfaceError: Unable to load driver ''ODBC'' (underlying error: uninitialized constant DBI::DBD::ODBC) from

Hi, I am on a windows 2000 machine and want to use an ms access 97 database (*.mdb) as db backend. I did a clean install: ruby, gems, rails, odbc-rails. A test rails application connecting to a local mysql server is doing fine. I can also locally connect to the odbc connection "local_odbc_name" with the aqua data studio client. But now with rails. As soon as I change the adapter to