Upgrade Posit Professional Drivers

How to upgrade Posit Professional Drivers.
Important

Keeping ODBC drivers up to date We strongly recommend upgrading drivers to prevent security and administrative issues. Update drivers system-wide with at least the same frequency as other Posit products.

If you are working with the Oracle database, you must install version 19.21 of the Oracle Instant Client. If the installation of the Oracle Instant Client isn’t used anywhere else by the system, remove it since it’s no longer supported.

RStudio Desktop Pro

Uninstall and reinstall the desired drivers following these instructions.

Posit Workbench and/or Posit Connect

Upgrading from RStudio Professional Drivers 1.6.0 and newer

Posit End User License Agreement

This page includes instructions for downloading Posit professional products. Download and/or use of these products is governed under the terms of the Posit End User License Agreement. By downloading you agree to the terms posted there.

  • Download and install the .rpm or .deb as appropriate for your OS for the current 2024.03.0 version to replace the previously installed drivers
  • To ensure each entry has the correct version and the driver file path, update the driver entries in /etc/odbcinst.ini. Find this information in the sample file /opt/rstudio-drivers/odbcinst.ini.sample
  • Add/modify any other settings for the driver that have changed in the newer version as seen in the sample file

For example, the contents of a sample /etc/odbcinst.ini using the 2021.10.0 drivers displays next to commented out entries using the 1.6.0 drivers. This shows the relevant changes that to make to the driver entries.

File: /etc/odbcinst.ini
# Old 1.6.0 driver entries - these should be deleted but are commented out as an example
#[PostgreSQL]
#Driver = /opt/rstudio-drivers/postgresql/bin/lib/libpostgresqlodbc_sb64.so
#Installer = RStudio
#Version = 1.6.0
#
#[MySQL]
#Driver = /opt/rstudio-drivers/mysql/bin/lib/libmysqlodbc_sb64.so
#Version = 1.6.0
#Installer = RStudio
#
# New 2021.10.0 driver entries
[PostgreSQL]
Driver = /opt/rstudio-drivers/postgresql/bin/lib/libpostgresqlodbc_sb64.so
RStudioVersion = 2021.10.0
Installer = RStudio Pro Drivers
Version = 1.4.32.1000

[MySQL]
Driver = /opt/rstudio-drivers/mysql/bin/lib/libmysqlodbc_sb64.so
RStudioVersion = 2021.10.0
Version = 1.1.1.1001
Installer = RStudio Pro Drivers

Upgrading from RStudio Professional Drivers 1.4.0

In version 1.4.0, the installer script installed the professional drivers.

Starting in version 1.6.0:

  • This version replaces the installer script used in version 1.4.0

  • Professional Drivers are now downloaded and installed using any of the following methods:

    • .rpm packages
    • .deb packages
    • Your system’s package manager

This release provides new functionality and these new methods make future upgrades of the Professional Drivers much easier.

We recommend removing existing installations of version 1.4.0 of the Professional Drivers. This avoids the accidental use of the wrong version of the drivers in your R and Python code. If desired, both versions of the drivers can coexist in the same system and used without issues.

To uninstall version 1.4.0 of the Professional Drivers, remove the directory that they install to.

Back to top