Installing RStudio Professional Drivers
RStudio Workbench and/or RStudio Connect
These procedures are intended for IT Admins that need to install the RStudio
Professional Drivers on a server.
Install RStudio Pro Drivers for Linux
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 Workbench and/or RStudio Connect is installed or
- Install RStudio Pro Drivers on your desktop
Step 1. Install dependencies
Step 2. Download and install
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
that is preconfigured with the names and locations of the RStudio Professional
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
To create a new DSN:
- Edit the file
- Add a new entry for your desired database type by copying over the sample from
- Ensure that the
Driver setting in the DSN refers to the corresponding driver name or path listed in
- Modify the entry with your desired connection parameters
For example, to add a SQL Server connection:
Driver = SQLServer
Server = my.server.name
Database = dbname
Port = 1433
To test this connection, run the following command:
Refer to the article on Troubleshooting RStudio Professional
for additional information on troubleshooting the ODBC drivers and dependencies.
Upgrading from version 1.6.1
If you are using RStudio Professional Drivers version 1.6.1, or older, and
would like to upgrade, then please see our Upgrading
To continue to the Using RStudio Professional Drivers document, see the Usage documentation.