Download Drivers2018-10-05T11:13:06+00:00

Download RStudio Professional Drivers

Thank you for your interest in RStudio Professional Drivers. If you are using RStudio Server Pro, RStudio Connect, or Shiny Server Pro, then you can download and use RStudio Professional Drivers at no additional charge. Use our simple, easy to use installer to help you configure your system. In most cases, installation and configuration should be carried out by a system administrator. For detailed instructions see Getting Started with RStudio Professional Drivers. For general information, see our site on using Databases With R.

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 yum install unixODBC unixODBC-devel
From an R prompt install the odbc package:
> install.packages("odbc")

Download and install

Download the installer for RStudio Professional Drivers and make the file executable. Examine the help menu for options. This install script first downloads the drivers from RStudio, then extracts the drivers, and finally configures odbcinst.ini with the location of the drivers. We recommend installing drivers with root access under /opt/rstudio-drivers.

$ sudo wget https://drivers.rstudio.org/7C152C12/odbc-install.sh
$ sudo chmod +x odbc-install.sh
$ sudo ./odbc-install.sh --help
64bit
You can install all available drivers on your server by running the following command:

$ sudo ./odbc-install.sh

If you want to install a single driver (e.g. you only want to install SQL Server), then you can specify the driver name:

$ sudo ./odbc-install.sh --sqlserver
32bit
You can install all available drivers on your server by running the following command:

$ sudo ./odbc-install.sh --x32

If you want to install a single driver (e.g. you only want to install SQL Server), then you can specify the driver name:

$ sudo ./odbc-install.sh --x32 --sqlserver

Advanced options

You can fetch, extract, and configure the installation process in distinct steps. This can be helpful if you are Installing RStudio Professional Drivers Offline. For more options see --help.

$ sudo ./odbc-install.sh --fetch
$ sudo ./odbc-install.sh --extract
$ sudo ./odbc-install.sh --configure

Next Steps

You should test 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. 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 apt-get install unixodbc unixodbc-dev
From an R prompt install the odbc package:
> install.packages("odbc")

Download and install

Download the installer for RStudio Professional Drivers and make the file executable. Examine the help menu for options. This install script first downloads the drivers from RStudio, then extracts the drivers, and finally configures odbcinst.ini with the location of the drivers. We recommend installing drivers with root access under /opt/rstudio-drivers.

$ sudo wget https://drivers.rstudio.org/7C152C12/odbc-install.sh
$ sudo chmod +x odbc-install.sh
$ sudo ./odbc-install.sh --help
64bit
You can install all available drivers on your server by running the following command:

$ sudo ./odbc-install.sh

If you want to install a single driver (e.g. you only want to install SQL Server), then you can specify the driver name:

$ sudo ./odbc-install.sh --sqlserver
32bit
You can install all available drivers on your server by running the following command:

$ sudo ./odbc-install.sh --x32

If you want to install a single driver (e.g. you only want to install SQL Server), then you can specify the driver name:

$ sudo ./odbc-install.sh --x32 --sqlserver

Advanced options

You can fetch, extract, and configure the installation process in distinct steps. This can be helpful if you are Installing RStudio Professional Drivers Offline. For more options see --help.

$ sudo ./odbc-install.sh --fetch
$ sudo ./odbc-install.sh --extract
$ sudo ./odbc-install.sh --configure

Next Steps

You should test 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. 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")

Download and install

Download the installer for RStudio Professional Drivers and make the file executable. Examine the help menu for options. This install script first downloads the drivers from RStudio, then extracts the drivers, and finally configures odbcinst.ini with the location of the drivers. We recommend installing drivers with root access under /opt/rstudio-drivers.

$ sudo wget https://drivers.rstudio.org/7C152C12/odbc-install.sh
$ sudo chmod +x odbc-install.sh
$ sudo ./odbc-install.sh --help
64bit
You can install all available drivers on your server by running the following command:

$ sudo ./odbc-install.sh

If you want to install a single driver (e.g. you only want to install SQL Server), then you can specify the driver name:

$ sudo ./odbc-install.sh --sqlserver
32bit
You can install all available drivers on your server by running the following command:

$ sudo ./odbc-install.sh --x32

If you want to install a single driver (e.g. you only want to install SQL Server), then you can specify the driver name:

$ sudo ./odbc-install.sh --x32 --sqlserver

Advanced options

You can fetch, extract, and configure the installation process in distinct steps. This can be helpful if you are Installing RStudio Professional Drivers Offline. For more options see --help.

$ sudo ./odbc-install.sh --fetch
$ sudo ./odbc-install.sh --extract
$ sudo ./odbc-install.sh --configure

Next Steps

You should test 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. 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.