Have you tried running the connection from inside just R (outside of RStudio)? It may not be an RStudio issue, but an issue with the odbc package itself. I would recommend giving it a shot in the terminal, just to be sure where the issue lies. I suspect that the issue is in the odbc package utilizing the driver.
Also, have you tried connecting with the Driver directly? i.e. specifying connection parameters directly and not using the DSN? That might be another approach to whittle down and be sure that the Driver is the issue.
I can't use the DSN in either the R console or RStudio Session. Same error, guess it is odbc package related.
I am able to connect with the driver and my credentials, but there is some encoding issue and the table names all have one character like h for hive and s for system.
@MattL Sorry for the delay in responding back. I definitely recommend hitting "Reply" or "@-mentioning" people to be sure they get a notification of your update!
In any case, this sounds like an issue that might be worth raising over at the odbc repo. I have seen some encoding issues over there and it would be great to get them documented / resolved!
Hey @MattL,
I am having the same issue after completely resetting my machine.
I didn't have this problem before, and everything worked fine. Now I have it, which tells me there's something about my configuration that is different from last time.