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 Windows 7 64-bit
# http://dacosta9.wordpress.com/2014/02/26/connecting-to-sql-server-with-r-with-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" , "C:/jdbc/sqljdbc_4.0/enu/sqljdbc4.jar" ,identifier.quote="`")
conn <- dbConnect(drv, "sqlserver://192.172.1.210:55158;databaseName=master", "sa", "password")
d <- dbGetQuery(conn, "select * from sys.databases where database_id <= 4 ")
summary(d)
# R.Version()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment