Connect to Azure SQL

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;;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:

1 Like

Thank you very much.