stewbawka
2010-Jun-25 20:39 UTC
activerecord + ms sql.. rowguid field for merge replication breaking inserts
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 ''phone home'' and replicate their data on our main sql server database. runnign the replication wizard changed my tables by adding a ''rowguid'' column and now activerecord breaks with the following error when i try to create a new record: [unixODBC][FreeTDS][SQL Server]Conversion failed when converting from a character string to uniqueidentifier.: INSERT INTO [companies] ([created_at], [name], [updated_at], [rowguid]) VALUES(''2010-06-25 20:23:06.032'', ''test'', ''2010-06-25 20:23:06.032'', ''newsequentialid('') what are my alternatives to get this to work again? -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.