Connecting SMSS to RStudio

General
1

Hello,

I need assistance in connecting SMSS to RStudio. My professor provided instructions on how to import a database into RStudio using odbc and OBI . The code below is his steps provided.

library(odbc)
library(odbi)
con <- dbConnect(odbc::odbc(), Driver="SQL Server", Server = ".", Database = "AdventureWorks2016", Trusted_Connection="True")

I also attempted to access it via a Youtube tutorial using RODBC https://www.youtube.com/watch?v=PoA23UWvXuc. My professor doesn't understand why I'm erroring out (attached file) and my school's support desk is unable to assist as well.

image
image1440×948 84.7 KB

2

This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.