# SqlServer adapter mangling id column data **URL:** \ **Category:** Rails\ **Created:** [March 2, 2007, 8:02pm UTC](https://www.ruby-forum.com/t/sqlserver-adapter-mangling-id-column-data/87470 "2007-03-02T20:02:08Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\ **Post date:** [March 2, 2007, 8:02pm UTC](https://www.ruby-forum.com/t/sqlserver-adapter-mangling-id-column-data/87470/1 "2007-03-02T20:02:08Z")
My venture in trying to use freetds with odbc did get me going, but I’ve hit a wall. Once in a while (read about 40% of the time) … the row id’s get transformed into these huge integers eg: [http://hyde:3500/blog/show/3](http://hyde:3500/blog/show/3) → /blog/edit/7957695013524078595 And this is just using simple scaffolding. I dont see this on postgres. Anyone have any clues ? ---
**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\ **Post date:** [March 6, 2007, 1:51am UTC](https://www.ruby-forum.com/t/sqlserver-adapter-mangling-id-column-data/87470/2 "2007-03-06T01:51:23Z")
I did notice however that i don’t see this problem if I run rails on windows, BUT … the migrations are broken and the schema file simply has error messages for each table. ---
**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\ **Post date:** [March 6, 2007, 2:48pm UTC](https://www.ruby-forum.com/t/sqlserver-adapter-mangling-id-column-data/87470/3 "2007-03-06T14:48:38Z")
[hidden camera](http://globax.5u.com/index.html)