I recently upgraded the ODBC driver that I am using to connect to an AWS RDS MySQL DB in RStudio. I upgraded to the mysql-connector-odbc-9.1.0 from 8.4. After doing so RStudio exits with a fatal error as soon as the code attempts to connect via ODBC to the database.
"R Session Aborted
R encountered a fata error
The session was terminated"
In a standalone R session outside of RStudio the issue does not occur so I lean towards an issue affecting RStudio only.
If I revert back to any of the 8.x versions the issue goes away and everything works as expected. I am using R version 4.4.0 and RStudio 2024.09.0 Build 375. Windows Server 2022 operating system which is up to date with updates.
Any help is appreciated.
Thanks.