similar to: DBI: connect succeeds in IRB, fails in Rails

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

Hi -- I''ve been having problems connecting to a SQL Server database that I thought might be related to the fact I was upgrading Rails to 2.0. However, I also was moving the project to my shiny new macbook. Anyway, after jumping through a few hoops (instaling DBI, etc.), I finally get to my latest error message: <error> DBI::InterfaceError: Could not load driver (no such file to

Hi, I''m getting some trouble in connecting to a sql server 2000 database with ActiveRecord-2.0.1 and ruby 186-26, from win XP. Using the next conenction config: ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :database => "nombre_bd", :username => "usu", :password => "contra" ) I have the next error:

Hi everyone, It''s been more than a month since I last fired up Ruby or ActiveRecord, so imagine my surprise when, after getting the latest source and running the unit tests for MySql, I was greeted with a screen full of errors. I''ll come back to the MySql errors later. What follows is the output I get when I run the tests for SQL server. I installed ruby with the one-click

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

After installing One-Click Rails and Postgres 8.1 on Windows, I tried to install the pure-ruby postgres adapter by running gem install postgres-pr It installed fine, and I can do this: G:\InstantRails\rails_apps>irb irb(main):001:0> require "rubygems" => true irb(main):002:0> require "postgres" => true But then if I specify in my config/database.yml to use

Has anyone actually gotten the activerecord-sybase-adapter to work in Rails2? I can''t seem to, and can''t figure out why. I am on RedHat linux. I have the sybase client libraries installed, I have the adapter installed. After installing the patch at https://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/2455-update-for-sybase_adapter#ticket-2455-4 to get a slightly

Hey fellows, I am a novice to ruby and ror, but really addicted to it. As a graduate student, I need master thesis topic around Ruby aor ROR. Can anyone suggest some for me? Regards/Buyan -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

I am having a strange issue. I have upgraded to ruby 1.9.1 to do some testing on one of my machines. My app accesses a MSSQL database to pull in some information. Everything worked fine with ruby 1.8.6, but now if I try to navigate to a page that accesses that database I get this error: DBI::InterfaceError in PagesController#company Unable to load driver ''ODBC'' (underlying

Say I have a string : "012345678". I have a column in a table which also stores strings. I want to find all rows which match that string of numbers in that order. That is, "012345678" will match, but "012-34-5678" will, and "012sneeze345bless67you8thanks" also will. Do I have to do something like: ThisIsMyString = "012345678" fits =

Hi I am currently recruiting for a number of freelance contracts and permanent internal positions, both junior and senior, for Europe''s largest and most dynamic Ruby on Rails development projects, offering the chance to work alongside some of the industry''s leading figures in the Web 2.0 development community. Selected locations include Germany (eg Berlin, Munich, Hamburg,

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

Hello, I'm looking forward to make a USB token working with Wine. The token is used by CMBChine online bank ( http://english.cmbchina.com/ ) , and the Client for the token can be download from http://121.15.172.132/download/PB/PbSetup60.exe ( http://www.cmbchina.com/cmbpb/v36/pb.htm ) I've follow http://wiki.winehq.org/USB, but get some trouble. Here is what I've tried: 0. Build and

I''ve been asked to make my app work on Windows Server 2003 and connect to SQL Server. I''m having trouble getting connected to SQL Server. It fails as follows: is not a class/module C:\InstantRails-1.0\ruby\lib\ruby\site_ruby\1.8\dbi\dbi.rb:499 in ''load_driver'' So, I went through the instructions on the Rails/MSSQL page. I installed the ADO.rb stuff. Also,

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

Hey :) We''re doing this large project, based on a legacy MSSQL database. We''ve had some issues, particularly with datetimes, when communicating with the server. These issues dissapeared after updating our ruby-odbc package to a new version (we''re developing on Linux and MacOS X, and connecting to the remote MSSQL server via FreeTDS and UnixODBC/iODBC, and then ruby-odbc

This is a problem I know other people have been having. I''m on Rails 2.3.5 on a dual core 2.1Ghz Macbook Pro 2.1 with 3Gb of ram and 800Mb+ inactive memory. Things should be fast. Sometimes things run slowly, but nothing nearly as slowly as rails. irb starts in milliseconds. Even Java maven tasks are pretty fast. Rails on the other hand takes a pitiful 1:30 minutes to start - the

Hello. Between 0.9.52 and 0.9.53 were several changes that lead to a big slowdown on starting wine. The log traces give the following info: wine: Call from 0x7ee3812c to unimplemented function ntoskrnl.exe.KeQueryActiveProcessors, aborting wine: Unimplemented function ntoskrnl.exe.KeQueryActiveProcessors called at address 0x7ee3812c (thread 000f), starting debugger... Unhandled exception:

Hi all, for first sorry for my english. I''ve a little problem with RMagick on Windows Vista. I''ve decided to use the "Paperclip" plugin an it works fine, than I''ve decided to install RMagick in order to create image thumbs but ... even if i followed the instructions i can see an error like: "Unable to load module ...

Trading up to 10 google wave invites for a fast, powerful Rails host that provides me with a top level domain: ie: webwebwebwebweb.com or wwwww.com Or similar offers. Send me an email or post here. -- Posted via http://www.ruby-forum.com/.