I have already set up an Azure SQL Database and loaded results into it from my local machine via R (RODBC) successfully. I can do queries in R Studio with no problem.
However, when I use the same code in the Execute R Script module in the ML studio, I get an error that the connection is not open.
The reason Reader or Import Data module is not working for my case is that I am creating an API that provides me with the information to query the database before doing analytics. The database is very big and I do not want to load the whole table and then use project columns, etc.
What do I need to change? I have tried different strings for the driver with no avail.
Any help is really appreciated