Download RStudio Professional Drivers v1.4

RStudio Professional Drivers is a free add-ons that is only available for use with RStudio Server Pro, RStudio Connect, and Shiny Server Pro. Please contact sales@rstudio.com if you’d like to purchase one of our professional products, or support@rstudio.com if you encounter any issues or have suggestions for additional features or improvements.

Download or use of RStudio professional drivers is governed under the terms of the RStudio End User License Agreement.

By downloading you agree to the terms posted here.

Prerequisites

Make sure you satisfy all the System Requirements for RStudio Professional Drivers. You will need to install the unixODBC driver manager if it is not already installed on your server and the odbc package in R.

$ sudo apt-get install unixodbc unixodbc-devel
From an R prompt install the odbc package:
> install.packages("odbc")

Installing

Use the odbc-install.sh installer script to download, extract, and configure the RStudio Professional Drivers. All drivers will be installed into the working directory, and the odbcinst.ini configuration file will be updated by default. To install a specific driver or for other advanced options set the --help flag or see Using the Installer for more instructions. We recommend installing under /opt/rstudio-drivers.

64bit

$ sudo wget -O - https://drivers.rstudio.org/7C152C12/odbc-install.sh \
 | bash -s --

32bit

$ sudo wget -O - https://drivers.rstudio.org/7C152C12/odbc-install.sh \
| bash -s -- --x32

Upgrading

Use the --reinstall flag to upgrade drivers. Reinstalling will download, extract, and configure new drivers on top of the existing ones. Warning: Use caution when reinstalling drivers. Any customizations you made to odbcinst.ini since the last install will be removed. If you want to have fine grain control over the installation process, you can fetch, extract, and configure drivers in distinct steps. Set the --help flag or see Using the Installer for more instructions.

Next Steps

You should test database connections from the command line before creating new connections in R. You can test connections by running isql, a command line tool for interactive SQL. If you are having problems connecting to your databases from RStudio, it’s likely that your system is not configured properly. For example, Oracle connections require Instant Client in addition to the Oracle driver. Driver-specific dependencies can be discovered with the ldd tool. You can also enable driver logging when troubleshooting connections. If you continue to have problems connecting, see our guide on Troubleshooting Connections.

Prerequisites

Make sure you satisfy all the System Requirements for RStudio Professional Drivers. You will need to install the unixODBC driver manager if it is not already installed on your server and the odbc package in R.

$ sudo yum install unixODBC unixODBC-devel
From an R prompt install the odbc package:
> install.packages("odbc")

Installing

Use the odbc-install.sh installer script to download, extract, and configure the RStudio Professional Drivers. All drivers will be installed into the working directory, and the odbcinst.ini configuration file will be updated by default. To install a specific driver or for other advanced options set the --help flag or see Using the Installer for more instructions. We recommend installing under /opt/rstudio-drivers.

64bit

$ sudo wget -O - https://drivers.rstudio.org/7C152C12/odbc-install.sh \
 | bash -s --

32bit

$ sudo wget -O - https://drivers.rstudio.org/7C152C12/odbc-install.sh \
| bash -s -- --x32

Upgrading

Use the --reinstall flag to upgrade drivers. Reinstalling will download, extract, and configure new drivers on top of the existing ones. Warning: Use caution when reinstalling drivers. Any customizations you made to odbcinst.ini since the last install will be removed. If you want to have fine grain control over the installation process, you can fetch, extract, and configure drivers in distinct steps. Set the --help flag or see Using the Installer for more instructions.

Next Steps

You should test database connections from the command line before creating new connections in R. You can test connections by running isql, a command line tool for interactive SQL. If you are having problems connecting to your databases from RStudio, it’s likely that your system is not configured properly. For example, Oracle connections require Instant Client in addition to the Oracle driver. Driver-specific dependencies can be discovered with the ldd tool. You can also enable driver logging when troubleshooting connections. If you continue to have problems connecting, see our guide on Troubleshooting Connections.

Prerequisites

Make sure you satisfy all the System Requirements for RStudio Professional Drivers. You will need to install the unixODBC driver manager if it is not already installed on your server and the odbc package in R.

$ sudo zypper install unixODBC unixODBC-devel
From an R prompt install the odbc package:
> install.packages("odbc")

Installing

Use the odbc-install.sh installer script to download, extract, and configure the RStudio Professional Drivers. All drivers will be installed into the working directory, and the odbcinst.ini configuration file will be updated by default. To install a specific driver or for other advanced options set the --help flag or see Using the Installer for more instructions. We recommend installing under /opt/rstudio-drivers.

64bit

$ sudo wget -O - https://drivers.rstudio.org/7C152C12/odbc-install.sh \
 | bash -s --

32bit

$ sudo wget -O - https://drivers.rstudio.org/7C152C12/odbc-install.sh \
| bash -s -- --x32

Upgrading

Use the --reinstall flag to upgrade drivers. Reinstalling will download, extract, and configure new drivers on top of the existing ones. Warning: Use caution when reinstalling drivers. Any customizations you made to odbcinst.ini since the last install will be removed. If you want to have fine grain control over the installation process, you can fetch, extract, and configure drivers in distinct steps. Set the --help flag or see Using the Installer for more instructions.

Next Steps

You should test database connections from the command line before creating new connections in R. You can test connections by running isql, a command line tool for interactive SQL. If you are having problems connecting to your databases from RStudio, it’s likely that your system is not configured properly. For example, Oracle connections require Instant Client in addition to the Oracle driver. Driver-specific dependencies can be discovered with the ldd tool. You can also enable driver logging when troubleshooting connections. If you continue to have problems connecting, see our guide on Troubleshooting Connections.