con <- dbConnect(odbc::odbc(), "MSSQL2", UID = "uid", PWD = "pswd")
seems to connect (no error) but instead of showing tables from my database, it shows: mse, md, SI, tmd, and TsD. I have no idea what those are?!!? The DSN MSSQL2 is working from Python and other apps.
Also tried:
db <- odbcConnect("MSSQL2",uid="uid",pwd="pwd")
Warning messages:
1: In RODBC::odbcDriverConnect("DSN=MSSQL2;UID=uid;PWD=pwd") : [RODBC] ERROR: state �Ӏ, code 20013, message x#|
2: In RODBC::odbcDriverConnect("DSN=MSSQL2;UID=uid;PWD=pwd") : [RODBC] ERROR: state �Ӏ, code 0, message x#|
3: In RODBC::odbcDriverConnect("DSN=MSSQL2;UID=uis;PWD=pwd") :
ODBC connection failed
What am I missing?