Install Posit Professional Drivers on Windows

Install on desktop methods  >  Install Pro Drivers for Windows

Overview

How to install Posit Pro Drivers for Windows.

Step 1. Install dependencies

  • Install the Visual C++ Redistributables.

    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 using the default installation path, 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

Install the drivers using RStudio Desktop Pro:

  • Open RStudio Desktop Pro.
  • Within the Connections pane, click New Connection.
  • Select the data source from the list.
  • Specify where to install the driver 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.
  • You can either:
    • Click Cancel
    • Enter connection details to test and/or establish a connection.

Step 3. Testing database connectivity

Test the database connectivity 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.
  • If you prefer, you can also set up ODBC DSNs to test and make database connections.
  • Define DSNs using the ODBC Data Source Administrator application. You can test DSN connectivity directly within ODBC Data Source Administrator.

Uninstallation

Uninstall the drivers 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.

Back to top