Has anyone had recent and confirmed success in connecting to an Azure SQL instance from RStudio.Cloud? I want to be able to query and update SQL.
I tried inline with odbc, RODBC, RSQLServer and had no luck.
Has anyone had recent and confirmed success in connecting to an Azure SQL instance from RStudio.Cloud? I want to be able to query and update SQL.
I tried inline with odbc, RODBC, RSQLServer and had no luck.
Try the following with RODBC
:
odbcDriverConnect(connection = "Driver=FreeTDS;TDS_Version=7.2;Server=mydns.database.windows.net;Port=1433;Database=mydatabase;Uid=myuserid;Pwd=mypass;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;")
You will need to allow access from the following IP addresses:
Thank you very much.