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.