ODBC OG/ActiveRecords

ruby-talk
1

Hi Ruby Talk,

I'd like to write an interface between an MS-Access DB and a Sybase Anywhere
DBs in Ruby.. Neither of these have native ruby drivers so I am resigned to
using Ruby-ODBC..

BUT: I would like to use a nice object-relational library like ActiveRecord or
OG.. Has anyone ever had any success using either over ODBC? I would expect
that if a generic "simple sql syntax" adapter were available it would likely
work on both DBs..

Thanks in advance!

2

Has anyone ever had any success using either over ODBC? I would expect
that if a generic "simple sql syntax" adapter were available it would likely
work on both DBs..

Generic ODBC adapters are problematic because the databases underneath might use different strategies for stuff like auto-incremented columns. A Access or Sybase adapter that goes through ODBC is certainly possible. I know that shashank and a few others were looking into that for Active Record at some point.

···

--
David Heinemeier Hansson,
http://www.basecamphq.com/ -- Web-based Project Management
http://www.rubyonrails.org/ -- Web-application framework for Ruby
http://www.loudthinking.com/ -- Broadcasting Brain

3

Hi Ruby Talk,

I'd like to write an interface between an MS-Access DB and a Sybase
Anywhere DBs in Ruby.. Neither of these have native ruby drivers so I
am resigned to using Ruby-ODBC..

BUT: I would like to use a nice object-relational library like
ActiveRecord or

OG.. Has anyone ever had any success using either over ODBC? I would
expect that if a generic "simple sql syntax" adapter were available it
would likely work on both DBs..

I've written stuff at work that uses Ruby/ODBC to query an Access file.

···

* Luke Galea (lgalea@gmmsolutions.com) wrote:

Thanks in advance!

--
Paul Duncan <pabs@pablotron.org> pabs in #ruby-lang (OPN IRC)
http://www.pablotron.org/ OpenPGP Key ID: 0x82C29562