For the past few months, I have been having issues querying my R to my team's SQL Server database (but had no problems until May)
Specifically, the connection seems to be made, but there are two primary issues:
The scheme/tables in the Databases tab of RStudio are all pure gibberish - and are not the schema/table names that I'd find if I looked at it in a different viewer.
When I do the queries, the queries give the right columns and column names, but incorrect contents (often there is a relationship between the correct data and the pulled, but I can't figure it out exactly.
I tried using Python to query (using
pandas read_sql() --- and the query is perfectly correct with no errors. But when I try using R (
odbc) -- I can't get it.
It is possibly the same issue referenced here on github -- but there doesn't seem to be an answer there.
I am using Mac OS
Has anyone encountered this issue?