/SQL/R dbConnect(odbc::odbc() to ms sql server remote

R dbConnect(odbc::odbc() to ms sql server remote

library(odbc)con <- dbConnect(odbc(),                 Driver = "SQLServer",                 Server = "mysqlhost",                 Database = "mydbname",                 UID = "myuser",                 PWD = rstudioapi::askForPassword("Database password")                 Port = 1433)

Source: support.rstudio.com

Similar codes

0 vote139 views1 answer
Into operator in sql
SQL
0 vote133 views1 answer
Power bi union columns
SQL
0 vote115 views1 answer
Get who is hired in month in sql
SQL
4 votes137 views2 answers
Oracle sql group by date year
SQL
0 vote139 views1 answer
Mysql error 1251
SQL
0 vote132 views1 answer
Amount of entries in a table psql
SQL
5 votes127 views2 answers
Get number of columns sql
SQL
0 vote118 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
10 votes203 views2 answers
Doublon sql
SQL
14 votes197 views1 answer
How to export db from mysql
SQL