src_sqlserver' is not an exported object from 'namespace:RSQLServer about rsqlserver HOT 8 CLOSED

There is also an example of how to connect on the repo's front page.

library(DBI)
con <- dbConnect(RSQLServer::SQLServer(), server = "TEST", database = 'DBItest')
dbWriteTable(con, "band_members", dplyr::band_members)
dbWriteTable(con, "band_instruments", dplyr::band_instruments)
# RSQLServer only returns tables with type TABLE and VIEW.
dbListTables(con)
#> [1] "band_instruments" "band_members"
dbReadTable(con, 'band_members')
#>   name    band
#> 1 Mick  Stones
#> 2 John Beatles
#> 3 Paul Beatles
dbListFields(con, 'band_instruments')
#> [1] "name"  "plays"

# Fetch all results
res <- dbSendQuery(con, "SELECT * FROM band_members WHERE band = 'Beatles'")
dbFetch(res)
#>   name    band
#> 1 John Beatles
#> 2 Paul Beatles
dbClearResult(res)
#> [1] TRUE

from rsqlserver.

What versions of dplyr and RSQLServer are you using?

from rsqlserver.

I am not sure. I am using 3.4.1 version for R. Please let me know how I can check the version of dplyr & RSQLServer. I just installed these today, using the commands
install.packages(‘devtools’)
install.packages("RSQLServer")

So I would think whatever version one gets by submitting those commands, are the versions I got. But I can check and get back to you if you let me know how to. I am new to R.

from rsqlserver.

Also, I used US OR as the mirror site

from rsqlserver.

packageVersion("RSQLServer")
packageVersion("dplyr")

from rsqlserver.

packageVersion("RSQLServer")
[1] ‘0.3.0’
packageVersion("dplyr")
[1] ‘0.7.1’

from rsqlserver.

This is expected (albeit undocumented in release notes - sorry). dplyr's mechanism for connecting to servers has changed with 0.7. Instead of

library(dplyr)
conn<-RSQLServer::src_sqlserver("servername”, database="database name or initial catalog")

You do the following

library(DBI)
library(dplyr)
dbi_conn<-dbConnect(RSQLServer::SQLServer(), ...) 

Then use dbi_conn wherever you would have used conn as per above.

from rsqlserver.

Thank you

from rsqlserver.