Installing RStudio Professional Drivers#
RStudio Server Pro and/or RStudio Connect#
These procedures are intended for IT Admins that need to install the RStudio Professional Drivers on a server.
Install RStudio Professional Drivers on your server
Install RStudio Professional Drivers on the same server where RStudio Server Pro and/or RStudio Connect is installed.
Use the following procedures to:
- Install RStudio Professional Drivers on the same server where RStudio Server Pro and/or RStudio Connect is installed or
- Install RStudio Pro Drivers on your desktop
Step 1. Install dependencies#
-
Install an OBDC driver manager using your system package manager:
$ sudo yum install unixODBC unixODBC-devel
$ sudo apt-get install unixodbc unixodbc-dev gdebi
$ sudo zypper install unixODBC unixODBC-devel
Additional steps for using the Oracle database driver
macOS Mojave
If you are using macOS Mojave (10.14) you must include the following in
~/.Renviron
:R_LD_LIBRARY_PATH=/Users/<username>/.rstudio-desktop/odbc/drivers/oracle/bin/lib
where
<username>
is replaced with your username.Oracle database
If you are working with the Oracle database, you must: - Install the Oracle Instant Client - Link the Oracle library directory to the RStudio Pro Drivers library directory by running the following command:
Terminal$ ln -s /usr/lib/oracle/12.2/client64/lib/* /opt/rstudio-drivers/oracle/bin/lib/
For more information on connecting to Oracle Databases look at this support article.
Additional steps for using the MongoDB driver
If you are working with the MongoDB in Ubuntu, you must link to
libsals2
from the system to the installation directory, and set theLD_LIBRARY_PATH
environment variable:Terminal$ ln -s /usr/lib/x86_64-linux-gnu/libsasl2.so /opt/rstudio-drivers/mongodb/bin/lib/libsasl2.so.3 $ LD_LIBRARY_PATH=/opt/rstudio-drivers/mongodb/bin/lib
Consider adding the second line, shown above, to a file inside of
/etc/profile.d/
which sets that environment's variable each time, so you don't have to.
Step 2. Download and install#
-
Download and install the RStudio Professional Drivers:
$ curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.6.1-1.el7.x86_64.rpm $ sudo yum install rstudio-drivers-1.6.1-1.el7.x86_64.rpm
$ curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers_1.6.1_amd64.deb $ sudo gdebi rstudio-drivers_1.6.1_amd64.deb
$ curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.6.1-1.sles12.x86_64.rpm $ sudo zypper --no-gpg-checks install rstudio-drivers-1.6.1-1.sles12.x86_64.rpm
$ curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.6.1-1.sles15.x86_64.rpm $ sudo zypper --no-gpg-checks install rstudio-drivers-.sles15.x86_64.rpm
Alternative download and installation method
In some cases, you may want to use an alternative installation method to install the RStudio Professional Drivers other than
.rpm
or.deb
packages, for example:- Installing drivers to a location other than
/opt/rstudio-drivers
- Installing drivers as a non-root user
- Installing a single driver or a subset of drivers
For this reason, we provide the drivers as a single compressed
.tar
file that can be manually extracted and moved to the desired location:-
Download RStudio Professional Drivers as a single compressed
.tar
file -
Refer to the detailed documentation for each driver for instructions on how to configure each driver.
- Installing drivers to a location other than
-
If you previously uninstalled the Pro Drivers version 1.4.0, and do not wish to use multiple versions of the Pro Drivers, then verify that the
/etc/odbcinst.ini
file is pointing to the new version of the drivers located at/opt/rstudio-drivers
.
Step 3. Configure driver locations#
The drivers install to /opt/rstudio-drivers/
. The ODBC driver names and
locations are specified in the /etc/odbcinst.ini
configuration file.
A sample of this file is included at /opt/rstudio-drivers/odbcinst.ini.sample
that is preconfigured with the names and locations of the RStudio Professional
Drivers.
-
You can use the following commands to backup your existing
/etc/odbcinst.ini
file and write the contents of the sample configuration file to/etc/odbcinst.ini
on your system:# Backup existing ODBC configuration file $ sudo cp /etc/odbcinst.ini /etc/odbcinst.ini.bak # Append sample ODBC configuration file into /etc/ $ cat /opt/rstudio-drivers/odbcinst.ini.sample | sudo tee -a /etc/odbcinst.ini
# Backup existing ODBC configuration file $ sudo cp /etc/unixODBC/odbcinst.ini /etc/unixODBC/odbcinst.ini.bak # Append sample ODBC configuration file into /etc/unixODBC/ $ cat /opt/rstudio-drivers/odbcinst.ini.sample | sudo tee -a /etc/unixODBC/odbcinst.ini
Step 4. Testing database connectivity#
Test your database connections from the command line before creating new
connections in RStudio. You can test connections by running isql
, a command
line tool for interactive SQL. Note that isql
requires you to create a data
source name first.
ODBC Data Source Names (DSNs) are defined in the /etc/odbc.ini
configuration
file.
- To create a new DSN, edit the file
/etc/odbc.ini
and add a new entry with the following contents:File: /etc/odbc.ini[test] Driver = SQLServer Server = my.server.name Database = dbname Port = 1433
The Driver
setting in the DSN should refer to the corresponding driver name or
path listed in /etc/odbcinst.ini
.
- To test this connection, run the following command:
Terminal
$ isql test
Troubleshooting#
Refer to the support article on Troubleshooting RStudio Professional Drivers for additional information on troubleshooting the ODBC drivers and dependencies.
Uninstallation#
-
Use the following commands to uninstall the RStudio Professional Drivers:
$ sudo yum remove rstudio-drivers
$ sudo apt-get remove rstudio-drivers
$ sudo zypper rm rstudio-drivers
Upgrading#
Upgrading from version 1.4.0
If you are using RStudio Professional Drivers version 1.4.0, or older, and would like to upgrade, then please see our Upgrading documentation.
To continue to the Using RStudio Professional Drivers document, see the Usage documentation.