Sign inSign up

lelkaklel/rstudio_for_sqlserver

By lelkaklel

Updated over 8 years ago

RStudio Server docker image prepared for connection to SQL Server

Image
0

376

lelkaklel/rstudio_for_sqlserver repository overview

RStudio Server docker image prepared for connection to SQL Server

Based on official rocker/geospatial image.

How to connect to SQL Server:

library(RODBC)
db <- odbcDriverConnect("driver=FreeTDS;server=<SERVER NAME OR IP>;port=1433;uid=<USER ID>;pwd=<PASSWORD>;database=<DATABASE NAMWE>;")
query <- " \
  select \
	name = @@servername, \
	version = @@version \
"
df <- sqlQuery(db, query)
View(df)

Tag summary

Content type

Image

Digest

Size

1.3 GB

Last updated

over 8 years ago

docker pull lelkaklel/rstudio_for_sqlserver