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
write to the field, it gives me a parsing error:
NoMethodError: private method ‘gsub!’ called for [0, 0, 0, 0, 0, 0, 224,
from c:/ruby/lib/ruby/1.8/date/format.rb:253:in ‘_parse’
from c:/ruby/lib/ruby/1.8/parsedate.rb:9:in ‘parsedate’
I think the problem comes down to sqlserver_adapter.rb, in the type_cast
method, asking timestamps to cast_to_time instead of something that
SQLServer is expecting. My questions are two:
- Does it look like I’ve traced this right?
- Who knows how a timestamp record needs to be casted in SQLServer?
I’ve looked at the data in a third-party tool, and it doesn’t give me
much: data of type BYTES (binary data?). I’ve spent quite a bit of time
over at Microsoft’s site today, but it seems they’ve either started
things around, or they’ve got some servers under maintenance, because
got blind links everywhere.
Thanks in advance for your comments.