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",
How can I incorporate the inforamtion about the driver path into dbConnect?