ODBC is isntalled, here is the command used:
con <- dbConnect(odbc::odbc(), "xxxxx", UID = 'uid', PWD = 'pwd')
Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Data source name not found and no default driver specified
output from this query to show installed drivers:
odbc::odbcListDrivers()
1 PostgreSQL Description ODBC for PostgreSQL
2 PostgreSQL Driver /usr/lib/psqlodbcw.so
3 PostgreSQL Setup /usr/lib/libodbcpsqlS.so
4 PostgreSQL Driver64 /usr/lib64/psqlodbcw.so
5 PostgreSQL Setup64 /usr/lib64/libodbcpsqlS.so
6 PostgreSQL FileUsage 1
7 MySQL Description ODBC for MySQL
8 MySQL Driver /usr/lib/libmyodbc5.so
9 MySQL Setup /usr/lib/libodbcmyS.so
10 MySQL Driver64 /usr/lib64/libmyodbc5.so
11 MySQL Setup64 /usr/lib64/libodbcmyS.so
12 MySQL FileUsage 1
13 FreeTDS Description Free Sybase & MS SQL Driver
14 FreeTDS Driver /usr/lib/libtdsodbc.so
15 FreeTDS Setup /usr/lib/libtdsS.so
16 FreeTDS Driver64 /usr/lib64/libtdsodbc.so
17 FreeTDS Setup64 /usr/lib64/libtdsS.so
18 FreeTDS Port 1433
19 MariaDB Description ODBC for MariaDB
20 MariaDB Driver /usr/lib/libmaodbc.so
21 MariaDB Driver64 /usr/lib64/libmaodbc.so
22 MariaDB FileUsage 1
Output from rpm -qa | grep oracle
oracle-instantclient-odbc-21.4.0.0.0-1.x86_64
pcp-pmda-oracle-5.3.1-5.el8.x86_64
oracle-instantclient-basic-21.4.0.0.0-1.x86_64
it looks like the drivers are installed, I'm definitely missing something.