dbConnect Rstudio Server

General
1

Hi,

I have been provided with some code for connecting to my Sybase DB from RStudio Server running on a linux server. I don't fully understand the linux file structures but I wish to take the messy code I was provided and simplify it by using the DBI::dbConnect() function.

The issue I have is the messy code that was provided to me uses a path to the Sybase drivers. Is it possible to specify driver path information using dbConnect()?

My code looks as follows:

drvg<- JDBC(driverClass = 'sybase.jdbc4.sqlanywhere.IDriver',
classPath = "/app/sybase_drivers/IQ-16_0/java/sajdbc4.jar",
identifier.quote="`")

How can I incorporate the inforamtion about the driver path into dbConnect?

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.