[R] R and Sybase

David James dj at research.bell-labs.com
Thu Dec 18 23:37:49 CET 2003


AFAIK the only way to connect to Sybase from R is with the RODBC
package, so you need to have an ODBC driver for Sybase -- either
one provided by Sybase or the FreeTDS ODBC driver from www.freetds.org.

Regards,

--
David

Peter McMahan wrote:
> Hi,
> I'm trying to get R connected to Sybase on a Linux
> machine.  I'm relatively new to databases,
> particularly the connectivity side.
> Do I have to use RODBC and install ODBC support on the
> system (a huge pain with Sybase, as you have to
> install a scaled-down version of Sybase itself on the
> system to get it to work with ODBC), or can I somehow
> use DBI to do it.  Other processes on the machine use
> DBI/DBD to talk to the database, but I have no idea
> how this would work with R.  The file at
> http://cran.r-project.org/doc/manuals/R-data.pdf makes
> it seem like the DBI package is only a front-end, and
> I would need something like "RSybase" to actually use
> it.
> Any help would be greatly appreciated.
> Thank you,
> Peter
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help




More information about the R-help mailing list