Sybase and ruby

ruby-talk
1

I am trying to configure Sybase and ruby in LINUX but not able to do
that. Is it necessary to install Sybase Client on PC ?

Attachments:
http://www.ruby-forum.com/attachment/35/database.yml

···

--
Posted via http://www.ruby-forum.com/.

2

You can use ODBC.

Install FreeTDS (Sybase is not only TDS based, they invented it) and
unixODBC, and configure your data source via TDS in /etc/odbc.ini. Then you
can use DBI with DBD/ODBC to access the database. Depending on your distro,
freeTDS and unixODBC should be available via your package management system,
DBI and DBD/ODBC probably are, too, though you may prefer to install them
via gems.

HTH,

Felix

···

-----Original Message-----
From: list-bounce@example.com
[mailto:list-bounce@example.com] On Behalf Of Vaibhav Ranadive
Sent: Thursday, August 02, 2007 2:07 AM
To: ruby-talk ML
Subject: Sybase and ruby

I am trying to configure Sybase and ruby in LINUX but not
able to do that. Is it necessary to install Sybase Client on PC ?

Attachments:
http://www.ruby-forum.com/attachment/35/database.yml

--
Posted via http://www.ruby-forum.com/\.

3

Felix Windt wrote:

Attachments:
http://www.ruby-forum.com/attachment/35/database.yml

--
Posted via http://www.ruby-forum.com/\.

You can use ODBC.

Install FreeTDS (Sybase is not only TDS based, they invented it) and
unixODBC, and configure your data source via TDS in /etc/odbc.ini. Then
you
can use DBI with DBD/ODBC to access the database. Depending on your
distro,
freeTDS and unixODBC should be available via your package management
system,
DBI and DBD/ODBC probably are, too, though you may prefer to install
them
via gems.

HTH,

Felix

Thanks for replying but I want to configure with SUSE linux 10 and ODBC
will work for Windows

···

--
Posted via http://www.ruby-forum.com/\.

4

There are ODBC implementations for many platforms, including Linux. I'm
using Ruby against MS-SQL databases (also TDS based, the first MS-SQL was
built on Sybase) from RHEL servers and Ubuntu desktop machines via the
mechanisms I described.

I did a quick search and it appears SLED10 comes with unixODBC packages via
yast, though there do not appear to be any FreeTDS packages. Unless you can
find third party for that, you may have to compile it, which is fairly easy
to do.

Felix

···

-----Original Message-----
From: list-bounce@example.com
[mailto:list-bounce@example.com] On Behalf Of Vaibhav Ranadive
Sent: Thursday, August 02, 2007 5:28 AM
To: ruby-talk ML
Subject: Re: Sybase and ruby

Felix Windt wrote:
>> Attachments:
>> http://www.ruby-forum.com/attachment/35/database.yml
>>
>> --
>> Posted via http://www.ruby-forum.com/\.
>>
>
> You can use ODBC.
>
> Install FreeTDS (Sybase is not only TDS based, they
invented it) and
> unixODBC, and configure your data source via TDS in /etc/odbc.ini.
> Then you can use DBI with DBD/ODBC to access the database.
Depending
> on your distro, freeTDS and unixODBC should be available via your
> package management system, DBI and DBD/ODBC probably are,
too, though
> you may prefer to install them via gems.
>
> HTH,
>
> Felix

Thanks for replying but I want to configure with SUSE linux
10 and ODBC
will work for Windows
--
Posted via http://www.ruby-forum.com/\.

5

Felix Windt wrote:

>>
Depending
Thanks for replying but I want to configure with SUSE linux
10 and ODBC
will work for Windows
--
Posted via http://www.ruby-forum.com/\.

There are ODBC implementations for many platforms, including Linux. I'm
using Ruby against MS-SQL databases (also TDS based, the first MS-SQL
was
built on Sybase) from RHEL servers and Ubuntu desktop machines via the
mechanisms I described.

I did a quick search and it appears SLED10 comes with unixODBC packages
via
yast, though there do not appear to be any FreeTDS packages. Unless you
can
find third party for that, you may have to compile it, which is fairly
easy
to do.

Felix

Thanks a Lot Felix ...

I am using NetBeans. Now I want to access Sybase databse moreover is it
necessary to configure anything else for Netbeans.

···

--
Posted via http://www.ruby-forum.com/\.