Install Posit Professional Drivers for Windows

RStudio is now Posit!

Our professional products have been renamed to Posit Connect, Posit Workbench, Posit Package Manager, Posit Cloud, and Posit Academy so it’s easier for folks to understand that we support more than just R. Please review our Blog post/FAQ to answer commonly asked questions about the rebrand.

Step 1. Install dependencies

• Install the Visual C++ Redistributables.

  Additional steps for using the Oracle database driver

  If you are working with the Oracle database, you must:

  • Install version 19.3 of the Oracle Instant Client.

  • Unzip the contents of the downloaded folder.

  • Copy the contents of the folder to the \lib subfolder in the installation directory of the driver.

  • If the default installation path is used, this directory is:

    C:\Users\<user>\AppData\Local\RStudio-Desktop\odbc\drivers\oracle\bin\lib
    

  For more information on connecting to Oracle Databases, reference the Connecting to Oracle databases with Posit Professional Drivers Support Article.

Step 2. Install the drivers

The drivers are installed using RStudio Desktop Pro:

• Open RStudio Desktop Pro.
• Within the Connections pane, click New Connection.
• Select the data source from the list.
• Specify where the driver will be installed and click Next.
  The default path is:

  %LOCALAPPDATA%\RStudio\ODBC\Drivers
  

• When prompted to allow this app to make changes to your device, click Yes.
• When prompted to continue, click Yes.
• Click Ok.
• After installation completes, click Next. The driver has been installs.
• You can either:
  • Click Cancel
  • Enter connection details to test and/or establish a connection.

Step 3. Testing database connectivity

Database connectivity can be tested directly from within RStudio Desktop Pro:

• Open RStudio Desktop Pro.
• Within the Connections pane, click New Connection.
• Select the data source from the list.
• Enter the requested information and click Test.
• If prompted, enter the database password.

Configure ODBC DSNs for testing and making database connections

• If you prefer, you can also set up ODBC DSNs to test and make database connections.
• DSNs can be defined using the ODBC Data Source Administrator application. You can test DSN connectivity directly within ODBC Data Source Administrator.

Uninstallation

The drivers are uninstalled using RStudio Desktop Pro:

• Open RStudio Desktop Pro.
• Within the Connections pane, click New Connection.
• Select the data source from the list.
• Click Uninstall....
• When prompted to uninstall the driver, click Yes.
• When prompted to allow this app to make changes to your device, click Yes.
• When prompted to continue, click Yes.
• Click Ok.

This removes the driver files and deletes registry entries that reference the driver.

To continue to the Using Posit Professional Drivers document, see the Usage documentation.