Ruby, rails, maxdb

(Kristian Rink) #1

Hi all;

being about to take a deep dive into ruby/rails (wanted to do this quite
some time ago already) for developing a small intranet application, one
short question: Around here we're running the GPL'ed SAP MaxDB to serve,
well, SQL for several inhouse applications, and I'd like to connect
ruby/rails to that database. I see there obviously is a working ODBC
implementation for ruby, and the MaxDB linux/odbc drivers work pretty
reliable. Only thing bugging me is that, looking through the rails
documentation, I only see database adapters for mysql, postgresql,
sqlite, oracle, sqlserver. Is there a way to use odbc / MaxDB instead? I
don't mind using postgresql, but this would be, say, the "least best"
option. :wink:

Thanks in advance and have a great new week everyone
Kris

···

--
Kristian Rink * http://www.fotolog.net/kawazu * http://zimmer428.net
icq: 48874445 * jab: kawazu@jabber.ccc.de * fon: ++49 176 2447 2771
"Sei Du selbst die Veränderung, die Du in der Welt wünschst." (Gandhi)

(DHH) #2

Only thing bugging me is that, looking through the rails
documentation, I only see database adapters for mysql, postgresql,
sqlite, oracle, sqlserver. Is there a way to use odbc / MaxDB instead?

There's no generic ODBC driver for Active Record because databases
exposed through that are still different enough that we can't handle
them in the same way. Thus, you can certainly use ODBC as a way to
create a MaxDB driver, but a generic ODBC driver is not of much use.

I believe we had a thread on the problems trying to do an ODBC driver
that worked both for Access and SQL Server some time back for further
reference.

···

--
David Heinemeier Hansson
http://www.loudthinking.com -- Broadcasting Brain
http://www.basecamphq.com -- Online project management
http://www.backpackit.com -- Personal information manager
http://www.rubyonrails.com -- Web-application framework