From: Yohanes Santoso <ysantoso-rubytalk@...>
Date: 2005-11-05T01:19:05+09:00
Subject: Re: MS SQL Access from Ruby in Windows

"Dave Burt" <dave@burt.id.au> writes:

> Alexey wrote:
>> Horacio Sanson wrote:
>>
>>>Can someone point me where to learn how to access a MS SQL 2000 database 
>>>server from within ruby in a Windows machine??
>>>
>> You need ADO driver for DBD. Here is how you get it into One-Click Ruby 
>> Installer.
>
> That's one way, but you don't need it. The Windows One-Click installer comes 
> with DBI and the ODBC DBD already installed - you can use DBI/ODBC out of 
> the box.
>
> Make a DSN, say "foo", and
>
> require 'dbi'
> dbh = DBI.connect("dbi:odbc:foo")
>
> and Bob's your uncle.
>
> Cheers,
> Dave

Just yesterday I was trying the ODBC DBD and encountered SEGV when I
call stored procedures in a certain way. Definitely some memory
corruption is going on as commenting out some ruby codes that are never
accessed or adding some bogus ruby code would cause SEGV.

I ended up using jruby with the jtds driver to access mssql2k, and
found myself thinking about dbd:jdbc:

your code <--> local ruby <--> drb on local machine <--> drb on remote
machine <--> remote jruby <--> remote jdbc driver

YS,