Hello --
I'm having some trouble making an ODBC connection to my data sources within R Studio.
install.packages("odbc")
install.packages("DBI")
library(odbc)
library(DBI)
con <- dbConnect(odbc::odbc(), myDSN, uid = myUID, pwd = myPWD)
In the "Connections" tab, it shows that I'm connected to the DSN. When I drill into the connection it shows"(No Tables)". Similarly, when I try:
dbListTables(con)
character(0)
I tried the same code within R and could see all of my tables as I would expect to see them using dbListTables(con).
I tried other ways to connect to this data source and they are all working.
I'm running R version 4.1.2 and R Studio version 2021.09.2+382.
Thanks very much for taking the time to help me out.