similar to: SQLServer adapter fails to commit on save()

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class

Hello! I experienced problems with testing transactions which are supposed to be rolled back, but are not, because of transactional fixtures eliminating the inner transaction. Can this be worked around somehow without turning off transactional fixtures? Maybe savepoints can help this? Does anyone have any experience with savepoints to achieve nested transaction functionality? Both Postgres

Hi there, I''m running ROR 2.x on Win32 tried to run gem install activerecord-sqlserver-adapter --source http://gems.rubyonrails.org and get this: D:\>gem install activerecord-sqlserver-adapter -source http://gems.rubyonrails.org Bulk updating Gem source index for: http://gems.rubyonrails.org ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find

/usr/local/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb" -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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

Hi... I am new to RoR development, and Web development in general (but have about 25 years of IT/software experience - just not in the Web area)... I have a really good RoR 2.X book that I have read and reread a few times and starting to try to apply what I read... Have a Web app that I need to write at work, and prove to folks that RoR is THE_WAY, despite their ASP .NET protests otherwise... So,

The activerecord-sqlserver-adapter gem is still sort of available via gems.rubyonrails.org, but it will not install on machines that have Rails 2.1 (or its version of ActiveSupport) installed. This has been confirmed with versions of rubygems through 1.2. This seems to indicate that Rails is no longer tested against the MSSQL adapter and that the adapter is also no longer tested against Rails

I''m trying to connect to a SQL Server db. I thought I installed the DBI component per the instructions, but its not working. When trying to start the ruby server, I get the message: Please install the sqlserver adapter: `gem install activerecord- sqlserver-adapter` But when I try to install the repository, I get this error message: could not find activerecord-sqlserver-adapter

Hi! I would really like to find a way to allow me to write RSpec specifications for code that use database transactions. I know I can set config.use_transactional_fixtures = false in my spec_helper.rb. That works, and that''s great, but it will (I think) slow down my specs quite a bit. I would like to turn off transactional fixtures for just a single spec (describe), or even

I am running Rails 1.1.2 with Ruby 1.82-15. My database is Postgresql. I haven''t had any problems generating models, migrations, using scaffolds, and generally building and using my application, but I haven''t been able to get testing to work. I initially just ignored the problem and kept developing, but would like to add proper testing from here on out. Currently when I type

How do I get ''save'' to execute without commit? I have tried: ActiveRecord::Base.connection.begin_db_transaction # do some stuff that doesn''t issue a database COMMIT statement # then: @myObject.save # this issues a COMMIT but it shouldn''t! Shouldn''t it wait until I''ve called: ActiveRecord::Base.connection.commit_db_transaction ? what am

Folks, I checked my test_helper.rb and it has self.use_transactional_fixtures = true My code was generated with 1.1.2 and I''m using 1.1.3 right now after but the error persists. I googled for this issue and it appears that a require is missing or something like that. I can''t figure it out, please help! /opt/local/bin/ruby -Ilib:test

I just updated my Rails install to the most current Edge and my controller specs fail: 1) TypeError in ''The User Controller should be a user controller'' can''t convert nil into String Each spec fails the same way. <context string> <spec string> can''t convert nil into String Any ideas what''s up with this? Thanks, s.ross

Im having trouble with Testing models. im following the tutorials in the book Agile Web Development with Rails. if i execute the code product_test.rb, i get this error: ============================================================ 1) Failure: test_update2(ProductTest) [test/unit/product_test.rb:30]: <29.95> expected but was <99.95>. 3 tests, 11 assertions, 1 failures, 0 errors

Buenas, Alguno usa alguno de los paquetes de Microsoft R para la conexion a SQL Server? De ser asi, que paquete y que comandos usais? Yo hasta ahora he usado odbc, de Rstudio, pero me da siempre problemas con el tipo de datos que tiene SQLServer ... Un saludo Jes?s [[alternative HTML version deleted]]

Okay - so the sqlite bug reported a day or so ago on the list is real bug. I''m going to file something in the tracker for that... I also learned that before(:all)...after(:all) is not wrapped in a transaction, the way before(:each)...after(:each) is. Is there some reason behind this? Can you not wrap transactions inside transactions? Scott

Olly Betts, Has anyone tested the new Edit Distance(SQLServer) algorithm compared to the current one? If you need any inditional information or code, please let us know. Thank you.

Hi! I''ve just started using AR on top of SqlServer 2005 (through ADO: http://www.softiesonrails.com/articles/2006/06/28/activerecord-with-sqlserver-without-rails). Not a Rails site per se, but I''m using AR and ruby to build data aggregation tools. If you have used AR with SqlServer 2005 and met quirks or caveats of some kind, I''d be happy to get some feedback from your

I have been trying to find the adtiverecord adaptor for MS SQL server and attempted to install with the command found on the http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer wiki page: gem install activerecord-sqlserver-adapter --source=http:// gems.rubyonrails.org I then got the error message: ERROR: could not find activerecord-sqlserver-adapter locally or in a

Hi, Here im not able to connect with MS-SQLSERVER database with *.R-File. Previously i was able to do in R in different machine and configuration was R Ver-2.11.1 Package Installed : RODBC_1.3-2 And now where im doinig now there the same code im trying to execute but its not connecting. configuration is, R Ver-2.12 Package Installed : RODBC_1.3-2 - here iam trying to install (RODBC_1.3-6) which

So, I''ve used Rails to tie into a legacy system which is on SQL Server 2000 with a required timestamp field, DBTimeStamp. The field is defined in SQL Server as type timestamp, but when rails is pulling it in, it appears it may be casting to a datetime format. So, when I try to read or write to the field, it gives me a parsing error: NoMethodError: private method