SQL Server RODBC Connection

by 
library(RODBC)
dbhandle <- odbcDriverConnect('driver={SQL Server};server=mysqlhost;database=mydbname;trusted_connection=true')
res <- sqlQuery(dbhandle, 'select * from information_schema.tables')

More Related Contents:

  1. Installation of RODBC/ROracle packages on OS X Mavericks
  2. How to connect R with Access database in 64-bit Window?
  3. Failure to connect to odbc database in R
  4. How to make plots from distributed data from R
  5. Nested facets in ggplot2 spanning groups
  6. ggplot2: histogram with normal curve
  7. How to run R on a server without X11, and avoid broken dependencies
  8. Remove quotes from a character vector in R
  9. Collapse rows with overlapping ranges
  10. Joining aggregated values back to the original data frame [duplicate]
  11. geom_boxplot with precomputed values
  12. How to avoid: read.table truncates numeric values beginning with 0
  13. R – converting date and time fields to POSIXct with HHMMSS format
  14. How to select last N observation from each group in dplyr dataframe?
  15. Recommendations for Windows text editor for R [closed]
  16. Seeking workaround for gtable_add_grob code broken by ggplot 2.2.0
  17. Control the height in fluidRow in R shiny
  18. Multiple time series in one plot
  19. Perform multiple paired t-tests based on groups/categories
  20. What is about the first column in R’s dataset mtcars?
  21. R – ggplot2 issues with date as character for x-axis
  22. ggplot2: Setting geom_bar baseline to 1 instead of zero
  23. Plot background colour in gradient
  24. Stop lapply from printing to console
  25. R how can I calculate difference between rows in a data frame
  26. Preserve proportion of graphs using grid.arrange
  27. Remove unused factor levels from a ggplot bar plot
  28. Knit one markdown file to two output files
  29. given value of matrix, getting it’s coordinate
  30. Display HTML file in Shiny App

Leave a Comment