53-databases-R - Githubissues

rstudio / webinars

Code and slides for RStudio webinars

https://resources.rstudio.com/webinars

1.53k stars 1.41k forks source link

53-databases-R #39

Closed drkamarul closed 6 years ago

drkamarul commented 6 years ago

Hi @edgararuiz, excellent webinar. I am using Windows 10 Home version on my laptop. I could not make a connection with the SQLEXPRESS::datawarehouse database, when I run

library(odbc) library(DBI) con <- dbConnect(odbc(), Driver = "SQL Server", Server = "localhost\\SQLEXPRESS", Database = "datawarehouse", Trusted_Connection = "True")

The RStudio just got stuck here

This most probably happen because I do not have MS SQL Server. Is that right?

edgararuiz-zz commented 6 years ago

Thanks. That's right, you need to install MS SQL Express and also create, and populate, the database. The last section of the RMarkdown document provides the link to where to download Express and the steps to download the data, create the database/schemata/tables and populate them.

drkamarul commented 6 years ago

Oh .. It is down there. My bad. Thanks very much @edgararuiz .