I connected to a db using the below code
postab <- dbConnect(odbc::odbc(),
Server = "xxxxx",
Database = "postab",
UID = "dummy",
PWD = "dummy",
Driver="SQL Server"
)
I am trying to read the data the table using dbReadTable
Studentlist <-dbReadTable(postab,"view_name")
the data that I am read is a view in the database.
but I am getting this error.
Error in result_fetch(res@ptr, n) :
nanodbc/nanodbc.cpp:2966: 07009: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
Warning message:
In dbClearResult(rs) : Result already cleared
I don't understand this error. Tried looking for it but didn't understand.
I think it used to work but not working now. The version that I am using right is R 4.0.
Thank You,