From: Ben Schumacher <ben@...>
Date: 2002-09-23T22:28:56+09:00
Subject: Re: hurdles moving ruby programs from NT to Linux

Andrew-

You might want to check out FreeTDS (http://freetds.org/). Its a set of
libraries developed under LGPL that is designed to natively support the
protocol used by MS SQLServer on *nix boxes. I don't think there is a Ruby
library for this yet, so you'd have to write it yourself.

You might, also, be able to use the Sybase-CT library available from the
RAA at: http://www.ruby-lang.org/en/raa-list.rhtml?name=sybase-ctlib

The protocol that MSSQL uses is the same as the Sybase one.

Cheers,

bs.

On Mon, 23 Sep 2002, andrew queisser wrote:
> I've been using some Ruby programs on NT to access data on Oracle and
> MS SQLServer databases on two servers on our network. I've been using
> ADO but I'd be happy with ODBC or some other interface as well. The
> queries aren't fancy and there's not a whole lot of data being sent
> around so speed isn't the primary concern.
>
> Now I'd like to run the same scripts on a Linux box. Of course I don't
> have ADO anymore but I can't seem to find a direct way to access
> SQLServer. I've done some Google searches and found iODBC and unixODBC
> but they don't seem to allow me to go to SQLServer directly.
>
> What are my options?
>
> Thanks much,
> Andrew Queisser
>