Hurdles moving ruby programs from NT to Linux

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

Not speaking out of experience here, but have you looked at Ruby >> JRuby >>
JDBC path ?

“andrew queisser” andrew_queisser@hp.com wrote in message
news:ad2f1094.0209200937.55d7d3fa@posting.google.com

···

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

Also, take a look at :
www.freetds.org
www.sqsh.org.

HTH,

– shanko

“andrew queisser” andrew_queisser@hp.com wrote in message
news:ad2f1094.0209200937.55d7d3fa@posting.google.com

···

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

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

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?

Have you seen Ruby/ODBC [ODBC Binding for Ruby] … ? I used it
for a while, worked well for me.

Chris

“Shashank Date” ADATE@kc.rr.com wrote in message news:22uj9.28617$Xl5.200109@twister.rdc-kc.rr.com

Also, take a look at :
www.freetds.org
www.sqsh.org.

HTH,

– shanko
Thanks, I got that running, I think that was the major step.
Next I’ll try to get Ruby to talk to freetds.

Andrew