# Legacy Schemas dynamic find

**URL:** <https://www.ruby-forum.com/t/legacy-schemas-dynamic-find/160101>\
**Category:** Rails\
**Created:** [February 11, 2009, 8:35pm UTC](https://www.ruby-forum.com/t/legacy-schemas-dynamic-find/160101 "2009-02-11T20:35:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rambor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9de053/32.png) [@rambor](https://www.ruby-forum.com/u/rambor)\
**Post date:** [February 11, 2009, 8:35pm UTC](https://www.ruby-forum.com/t/legacy-schemas-dynamic-find/160101/1 "2009-02-11T20:35:50Z")

</div>

Hello,

I’m trying to put a rails face on a legacy database. It is an old Sybase  
11 database installation. I’ve gotten an ODBC connection working that  
uses unixODBC and FreeTDS to work. I’m also using the  
activerecord-odbc-adapter gem.

I’ve had to use set\_table\_name and set\_primary\_key to make it work so  
far. However, none of the dynamic find\_by methods work. I always get a  
method missing error. Also, find through association doesn’t work as  
well with the same error. Normal finds on the models work, but I was  
hoping I can shorthand some of this.

Am I SOL on this because it’s a legacy DB or is there something I can do  
or check to make that work?

If I can, that would save me some work writing find\_by\_sql calls.

Thank you.
