I am new to connecting to the database in R. I am using a script where this code used to work but we recently did some updates and now it isn't working anymore. I'm getting this error:
Error: nanodbc/nanodbc.cpp:1118: HY000: [SAP][ODBC Driver][SQL Anywhere]RAISERROR executed: TLS encryption is required for network database connections in CATAPULT 5.6.91.20 and later versions.
This is the code I was using to connect:
ch=odbcConnect("myDSN",believeNRows=F)
I am wondering if we now need to set up TLS encryption and I would need to adjust the R code slightly.
I did try to change the above code to this:
ch <-odbcDriverConnect(DBI::dbConnect(odbc::odbc(), .connection_string = "dsn=myDSN;uid=myUID;pwd=myPWD;"))
I got the same error. I've tried this in RStudio as well as VSCode.