similar to: ODBC Adapter woes

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

I''m currently trying to connect rails to a legacy SqlServer database. System is windows XP and my attempts to connect with activerecord sql adapter and ADO.rb file failed miserably (I wrote a mail about it before) So it seems like odbc adapter is more recent compared to sql adapter and probably more used. I''m using active_record_store as session store, and probably the first

So i had a boolean attribute in my model which gets interpreted to tinyint(1) in mysql by rails migrations. Now tinyint(1) accepts a range in mysql and i want to change my boolean attribute to an attribute which can accept 3 values(0,1,2). I made the change to the view and when i post the form selecting the selecting the value ''2'', it still gets saved as a ''0''.

http://dev.rubyonrails.org/ticket/1117 I''ve attached a patch to ticket 1117 which fixes it so that booleans are escaped as booleans, not integers. Specifically, this situation will now work find_all(["send_date=? and sent=?", Date.today, false]) Which matches peoples expectations, but it causes some problems with the postgresql unit tests. Specifically, the use of

Hello, there is a table that has a column TINYINT(1) called status. Through mysql console I see its value as 1 (when is true) but if I do this in Rails console: Mytable.status => true give me "true" rather "1". How could I change 1 to true using some method? Or true to 1? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "<dsn

Hey all -- I''ve been using enumerable char(1)''s with ''y'' and ''n'' values for my Boolean columns in Rails, but it strikes me there should be a better way. How do you setup columns that represent true/false-ness in your schemas on Rails? Wondering what kind of standard approaches there are other than me writing something like class MyEntity

Does anyone have any insight into why this is happening? C:\Users\Family\workspace\myapp>rake test (in C:/Users/Family/workspace/myapp) C:/Program Files/Ruby187/bin/ruby.exe: illegal switch in RUBYOPT: -F (RuntimeError) C:/Program Files/Ruby187/bin/ruby.exe: illegal switch in RUBYOPT: -F (RuntimeError) C:/Program Files/Ruby187/bin/ruby.exe: illegal switch in RUBYOPT: -F (RuntimeError) Errors

I''ve just written an ActiveRecord adapter for Informix. It lacks a pair of features that I will add later, but it works for me. I found this on the web: http://wiki.rubyonrails.com/rails/pages/HowToWriteAnActiveRecordAdapter and followed it, but when I get to $ rake test_informix I get the following error messages: -----------------------8<-----------------------

We are almost there to a final release. The uninstall issues have been fixed, and a few packages have been upgraded to more recent versions. Many thanks to Ryan Leavengood and Shahank Date who stepped in to help finish off this release! *** Only "show-stopper" problems will be fixed *** We are extreme short of manpower at the moment. So as much as I would like to address each and every

Hi everyone, I''m working on a new rails project and have to build it on top of a legacy oracle database. I''m trying to figure out how to get the number value from a NUMBER(1) datatype. So far I''m only getting a "true" value for 1 and "false" for any other number. From the console I can print out my object values and can see that there are number

Hi, I''ve installed coverage (gem install coverage) and try to run tests with -rcoverage option on, but following error occurs: ruby: No such file to load -- coverage (LoadError) I try: ruby -rcoverage mytest.rb 1. I have rubygems in evn var RUBYOPT 2. Gem seems to be installed properly (I can read doc via gems, the files exist in the ../gem/... dirs) Does anyone know what is the

RSpec-1.1.3 has been released. If you''re using RSpec and autotest, you''ll have to upgrade to RSpec-1.1.3 and ZenTest-3.9.0 at the same time. == Version 1.1.3 Maintenance release. * Tightened up exceptions list in autotest/rails_spec. Closes #264. * Applied patch from Ryan Davis for ZenTest-3.9.0 compatibility * Applied patch from Kero to add step_upcoming to story listeners.

All, I''m attempting to update my gems to 1.2 and I get the following: Install required dependency activesupport? [Yn] Y ERROR: While executing gem ... (Gem::InstallError) invalid gem format for c:/ruby/lib/ruby/gems/1.8/cache/activesupport-1.4.2.g em Anyone else seeing this? Anyone willing to try it to see what''s up? Thanks, Wes -- Posted via

After creating and installing a gem I get ''unintialized constant Wxruby2'' when trying to run wxRuby. Kevin, can you give me some pointers on getting this thing working? Roy

Hi, I''m having problems running my rails application in the following setup Unix/Apache/FastCgi/Oracle10g. I had my app running quite happy until I installed the OCI8 driver. When I try to load the app I get in the apache logs the famous "undefined method ''define_a_column'' for class OCI8:Cursor (NameError)" I think the problem is with the fastcgi set up

When I execute `rake` inside of a new webgen-0.5.12 project with ruby1.8 there is the error no such file to load -- webgen/webgentask /my/dir/Rakefile:11:in `require'' With ruby1.9 it works. Michael

I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "TM_Reporting_00001", :username => "<name>", :password

Hi all. I''m in a project right now where I''m using the ODBC adapter to connect to a MS Sqlserver DB (believe me, it''s not my choice). Is there any way to get the SQL queries being generated a la the log when using MySql? Thanks, Andrew --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

Twice now, I have had some frustration trying to get my gem path recognized without having to manually specify -rubygems on the command line. It''s under-documented in Ubuntu[1]. I''m thinking that we should definitely mention this issue in the README. Shouldn''t we also require ''rubygems'' in all our samples, to make it as easy as possible for folks to