similar to: Is SQL Server not supported in RoR on the Mac?

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 all... Please help me solve the issue. While trying to create a connection with MS SQL database in RubyOnRails, I''m getting a ‘Deprecated ..’ error. (I referenced a doc posted in net for the same.) System details: OS: Windows Xp Ruby version: 1.8.6 Rails: 2.1.2 Gems: 1.3.1 RadRails: 0.7.2

I''m having an error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template =>

I''ve got a left join problem of some sort connecting from linux FreeTDS/ODBC to SQL Server. It''s similar to the false post I had earlier, but this is a real problem. Here''s my code: def find_recipes_for_workorder @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :joins => ''left join workorder on

New to rails. Installed rails on my XP desktop, and setup my first app that will use an existing SQLServer database. I am able to connect to SQLServer using odbc with following code. require ''rubygems'' require ''ActiveRecord'' ActiveRecord::Base.establish_connection( :adapter => ''sqlserver'', :mode => ''odbc'', :dsn

Just starting to learn rails. All is going well, until I tried to hook up a database. "undefined method `model'' for ZingerController:Class" is the message I get from the server. I imagine I''ve left something out that is keeping me from connecting to the database, but I''m not exactly sure what. Your help is appreciated. bests, -rsr- session dump:

I have the following code in app/controllers/processjobs_controller.rb # class ProcessJobsController <ApplicationController def index @ProcessJobs = ProcessJobs.find(:all) end end # This is my route file .. ActionController::Routing::Routes.draw do |map| map.resources :ProcessJobs map.connect '':controller/:action/:id'' map.connect

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:

My databases.yml makes no mention of root and in my dev environment everything works fine, however following a deployment with Capistrano about an hour ago, I get the following error: PGError in HomeController#index FATAL: role "root" does not exist /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/postgresql_adapter.rb:713:in `connect''

Does any one know how to setup SQLserver with ruby1.9. It was working on an earlier version and now nothing works! I have installed the gems dbi ,dbd-odbc and activerecord-odbc-adapter and can connect in straight Ruby. However, using rails with database.yml nothing works! I hosed everything and reinstalled rails and now, I get Win32/Parite virus on ruby.exe. Any ideas? I''m losing

When I run the rake db:migrate command, I get this: C:\testror\depot>rake db:migrate --trace (in C:/testror/depot) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! 182: Le systÞme d''exploitation ne peut pas exÚcuter %1. - c:/ruby/ lib/ruby/gem

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Anyone know what''s going on with ActiveRecord Edge and 1.2RC1 unit tests. I get 13 failures from the "async_exec" method call. ie: test_callback_rollback_in_save(ConcurrentTransactionTest): ActiveRecord::StatementInvalid: NoMethodError: undefined method `async_exec'' for #<PGconn:0xb75a8754>: SET

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

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 Guys I am pretty new to Ruby. One of our client is using Firebird as his backend database. I have to create a script which will connect to his database, fetch some data and update few tables in MS-SQL database. Now problem is: i have installed FireRuby, got databaes, changed my database.yml file. I am trying to display all the users in Members table. but i am getting following error:

Hello, I have been using Sphinx with Thinking_sphinx plugin which works well on local development environment, but once I move it to production (shared host) I get this error and I''m not sure why linkamed-sE8khXQTlBmcZ8xLbwwaNw@public.gmane.org [~/public_html/linko/current/config]# rake thinking_sphinx:index RAILS_ENV=production (in

I''m writing a simple app that doesn''t need to use a database. I added :active_record to the config.frameworks -= line in environment.rb file. This lets me run ./script/generate fine without complaining about no connection. However if I try to run a functional test, it complains about no connection being established. Well...I don''t want a connection to be established.

Hello, I''m a newbie to rails and I am trying to do the Demo in the November Issue of Linux Journal. Things go fine go fine until I try to connect to my Postgres database (ver 8.1). At this point I get the following error message ---- RoR error and trace back ---- PGError in Admin#index could not connect to server: Permission denied Is the server running on host "localhost"

I just deployed my rails app to my production server. It''s all working locally, but when I switched it over to the production server (at dreamhost) I get this error: # Logfile created on Sun Aug 19 15:22:48 -0700 2007 by logger.rb/ 1.5.2.9 [19/Aug/2007:15:22:48 :: 1841] starting [19/Aug/2007:15:22:48 :: 1841] Dispatcher failed to catch: You have a nil object when you didn''t

Sorry if this has been covered, but I finally decided to upgrade to Rails 2.0 (running Leopard and previously at rails 1.2.6) so I could start using some of the great new features. I ran the usual "sudo gem install rails --include-dependencies" to upgrade and now my development environment is all out of whack. I suspected MySQL, but I''ve already made sure I was using the