similar to: SQLServer''s uniqueidentifier in migrate script

i got my app running with ms sql server as the database and everything worked fine. migrations, indexes, constraints, find, create, update, etc.. the app isn''t actually a web app, butwill be running isolated on severally diff machines that may not have consistent internet access.. part of the requirements was to setup replication so that eventually the separate instances would

i have a problem with the datetime format of rails. i am unable to save a dataset to the db. here''s the error message -- the original error message was in german, so i translated it -- i get: DBI::DatabaseError: Execute OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server Couldn''t convert a char-Datatype to datetime HRESULT error code:0x80020009

Hello people, I am starting to build an application in Rails using SQLServer. In fact, I''m rebuilding it from Java EE to Rails. I created a new project and managed to connect to the database using ODBC, so I ran a rake db:migrate. Everything worked fine: the database schema was copied to my schema.rb file. Here comes my problem: is there a command that creates ruby classes from the

Hi all, it seems like the acts_as_taggable is not capable to work with uniqueidentifier as the datatype of the primary key in the tags table. however, it works like a charm with int and autoincrement. could that be fixed any time soon? -- Posted via http://www.ruby-forum.com/.

I seem to be running into various issues between SqlServer and Rails, and so far have been able to solve everything save for a particular quirk when running unit tests. When I run "rake test:units" on my app, it gets so far as to run db:schema:load. I''m dealing with a legacy database, so it''s loading all sorts of tables that I don''t care about, but

Hello all, I''ve spent a while looking for a sniff of this on the wiki or google at large.. Does migrations work for SQL Server on 1.0 ? -- ------------------------------ Joyeux Noël ------------------------------ Peter Fitzgibbons _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

I am trying to upload word docs to an image column. I followed the cookbook for how to upload files and it works on a MySQL db (upload and download) on SQLServer however I get the following error DBI::DatabaseError: Execute OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server Operand type clash: text is incompatible with image HRESULT error code:0x80020009 Also I when

Good Evening, I need some advice. I am in a position at work where I''ve got the boss pretty excited about rails. I think I could swing the Next Generation version of our product to use rails as the platform, but I find myself a little hesitant to do so until I''ve answered a few issues that I''m hoping people on this list could help me with. Firstly, we are tied to

Hello, I wrote a RoR app on OSX and SQL Server. The DB uses SQL_Latin1, so I use Iconv to convert to UNICODE every dynamic text I show on the pages (Iconv.conv(''utf-8'', ''iso-8859-1'', string)). That''s been working fine until I deployed the app on a debian box. Since then, the accents are shown as question marks, and I don''t know why. The

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

Hello, Using Edge_Rails and SQL Server I get an error in my schema.rb file after issuing "rake migrate". database.yml --------------------------------- development: adapter: sqlserver database: triage_development username: user password: pass host: server schema.rb --------------------------------- # Could not dump table "categories" because of following

Thanks for the response - looks like I am going to have to bite the bullet and get on with it. From a Rails perspective, these databases are a mess, in fact from a SQL Server perspective they are a mess and the company knows it, what they won''t do is use some resource to clean them up. >From some initial testing, the framework seems to be ignoring the set_primary_key setting that I

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

Greetings: I am new to ROR and RadRails. All assistance will always be appreciated. My environment: Windows XP Ruby 1.8.6 Rails 2.2.2 Aptana Studio, build: 1.2.1.020234 RadRails 1.1.0.200812081651NGT I created a new ROR Project. When I attempted to run db:create --trace for the first time I got the following message: in C:/RailsApp/chbdepot) ** Invoke db:create (first_time) ** Invoke

Hiall, I was wondering how you guys are organizing your migrations files under db/migrate? I have like 60 database tables initially, and if I exercise migrations the way they should be exercised, I guess this will become even more files ... Now maybe you say 70 files ain''t that much anyway :) but the thing of course is that these files logically belong to different areas of my

Hi All I got this migration to work the first time I tried it, dropped the table and not the migration won''t create the table but does not show any errors. Here is the trace on the execution of the rake migrate: my-computer:~/forms lars$ rake migrate --trace (in /Users/lars/forms) ** Invoke migrate (first_time) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) **

Hi all, I am facing a problem while using rails "migrate" feature for creating tables in a database. Following are the details. I have 2 applications say "app1" & "app2". I want both of them to use same database say "testdb". For "app1", I create 3 models which in turn create 3 migration files with prefix, 001_, 002_ & 003_. Now I

All, I have two migration files, file 1 and file 2. For reasons that I don''t want to go into unless I must, I want to only run file 2 on my production database (file 1 contains a bunch of table creation stuff for already existing tables). I figured if I created a schema_info table and set the version in it to 1, then I could just run rake db:migrate RAILS_ENV=production and just

Hello All -- I am using jruby 1.6.7.2 with rails 3.2.11 to create a brown bag for several other developers. I cannot get the migration to work to save my life... In my database yaml file I have the following: --- development: adapter: jdbc driver: oracle.jdbc.driver.OracleDriver url: jdbc:oracle:thin:@localhost:1521:xe username: brownbag password: brownbag pool: 500 --- When I run:

"bitsweat" has given AR/SQLServer some love, but it''s still unhappy... http://dev.rubyonrails.org/changeset/6912 ------------------------------------------------------------------------ r6912 | bitsweat | 2007-05-31 10:15:56 -0700 (Thu, 31 May 2007) | 1 line Fix an edge case with find with a list of ids, limit, and offset. Closes #8437.