This is a follow-up to the (closed) thread I created here.
I am able to create an ODBC connection in R, but I am not able to access any of the tables within the connection. I followed the advice of installing an earlier version of Rstudio and that solved my problem. I finally got around to updating to the latest version and the same problem occurs.
sessionInfo()
R version 4.2.0 (2022-04-22 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19042)
Matrix products: default
locale:
[1] LC_COLLATE=English_United States.utf8 LC_CTYPE=English_United States.utf8 LC_MONETARY=English_United States.utf8 LC_NUMERIC=C
[5] LC_TIME=English_United States.utf8
attached base packages:
[1] stats graphics grDevices utils datasets methods base