Skip to content

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 the 19.x version 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 RStudio 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 RStudio Professional Drivers document, see the Usage documentation.

Back to top