# Sybase and ruby

**URL:** <https://www.ruby-forum.com/t/sybase-and-ruby/111069>\
**Category:** Ruby\
**Created:** [August 2, 2007, 11:06am UTC](https://www.ruby-forum.com/t/sybase-and-ruby/111069 "2007-08-02T11:06:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![vabb\_z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b9e5f3/32.png) [@vabb\_z](https://www.ruby-forum.com/u/vabb_z)\
**Post date:** [August 2, 2007, 11:06am UTC](https://www.ruby-forum.com/t/sybase-and-ruby/111069/1 "2007-08-02T11:06:53Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![vabb\_z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b9e5f3/32.png) [@vabb\_z](https://www.ruby-forum.com/u/vabb_z)\
**Post date:** [August 2, 2007, 12:29pm UTC](https://www.ruby-forum.com/t/sybase-and-ruby/111069/2 "2007-08-02T12:29:40Z")

</div>

> Attachments:  
> [http://www.ruby-forum.com/attachment/35/database.yml](http://www.ruby-forum.com/attachment/35/database.yml)
> 
> –  
> Posted via [http://www.ruby-forum.com/](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

---

<div class="post-metadata">

**Author:** ![vabb\_z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b9e5f3/32.png) [@vabb\_z](https://www.ruby-forum.com/u/vabb_z)\
**Post date:** [August 2, 2007, 2:27pm UTC](https://www.ruby-forum.com/t/sybase-and-ruby/111069/3 "2007-08-02T14:27:41Z")

</div>

Felix W. wrote:

> > Attachments:  
> > [http://www.ruby-forum.com/attachment/35/database.yml](http://www.ruby-forum.com/attachment/35/database.yml)
> > 
> > –  
> > Posted via [http://www.ruby-forum.com/](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

---

<div class="post-metadata">

**Author:** ![vabb\_z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b9e5f3/32.png) [@vabb\_z](https://www.ruby-forum.com/u/vabb_z)\
**Post date:** [August 2, 2007, 3:08pm UTC](https://www.ruby-forum.com/t/sybase-and-ruby/111069/4 "2007-08-02T15:08:03Z")

</div>

> > >
> 
> ## 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/](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

---

<div class="post-metadata">

**Author:** ![vabb\_z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b9e5f3/32.png) [@vabb\_z](https://www.ruby-forum.com/u/vabb_z)\
**Post date:** [August 3, 2007, 12:43pm UTC](https://www.ruby-forum.com/t/sybase-and-ruby/111069/5 "2007-08-03T12:43:16Z")

</div>

Felix W. 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/](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.
