Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Connecting to SQL Server with R using RJDBC and com.microsoft.sqlserver.jdbc.SQLServerDriver on Ubuntu
# http://dacosta9.wordpress.com/2014/02/26/connecting-to-sql-server-with-r-with-rjdbc/
# reference document on RJDBC
# http://cran.r-project.org/web/packages/RJDBC/RJDBC.pdf
# install.packages("RJDBC",dep=TRUE)
library(RJDBC)
drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver" , "/home/johndacosta/C/jdbc/sqljdbc_3.0/enu/sqljdbc4.jar" ,identifier.quote="`")
conn <- dbConnect(drv, "jdbc:sqlserver://192.172.1.210:55158;databaseName=master", "sa", "password")
d <- dbGetQuery(conn, "select * from sys.databases where database_id <= 4 ")
summary(d)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment