Skip to content

Install Posit Professional Drivers for Windows#

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.21 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.