Hello -- Sorry I'm late to the party. This error message can mean one of a few things in the context of an R + RJDBC + rJava --> JDBC --> SAS/SHARE connection, but each centers around an inabiity for the stack to properly find the component drivers. 1. Be sure you have downloaded BOTH required SAS JDBC drivers ( sas.core.jar and sas.intrnet.javatools.jar ) to the same directory on your machine. 2. Be sure you have an .Renviron file that explictly lists both of these files, in appropriate syntax for your platform. Example: Mac: CLASSPATH="/Users/my_user/Documents/JDBC_Drivers/sas.core.jar:/Users/my_user/Documents/JDBC_Drivers/sas.intrnet.javatools.jar" Windows: CLASSPATH="C:/Users/my_user/Documents/JDBC_Drivers/sas.core.jar;C:/Users/my_user/Documents/JDBC_Drivers/sas.intrnet.javatools.jar" Note the semicolon delimiter for the Windows version! 3. If you are connecting to WRDS, the .Rprofile code you were given (search the WRDS website for "Using R with WRDS") includes a path to sas.intrnet.javatools.jar. Make sure you update this path to reflect where you have actually placed this driver! It should be the same as in your .Renviron file. 4. If you are using RStudio, be sure that you have placed your .Renviron and .Rprofile files in a location that RStudio knows to look. This directory is controlled by the preference setting General > Default working directory (when not in a project). Bonus Info! Be sure you are using RJDBC version 0.2-5 or later! Version previous to 0.2-5 experienced a major bug that caused queries resulting in more than 32767 observations to return zero observations instead! Hope this helps someone!
... View more