Could not find function "collect"

[Slavek]

Hi,
I have been using this code for a while and everything was fine:

library(RODBC)

abc <- odbcConnect("LIVESTATS")
ABC.Service.data <- sqlQuery(abc, "SELECT * FROM LIVESTATS.MMF.ServiceFlat")
ABC.Service.dealers <- sqlQuery(abc, "SELECT * FROM LIVESTATS.MMF.Dealers WHERE DataTypeID=2")

A.Service.data <- collect(ABC.Service.data)
A.Service.dealers <- collect(ABC.Service.dealers)

but now I have this error:

Error in collect(ABC.Service.data) : 
  could not find function "collect"


Error in collect(ABC.Service.dealers) : 
  could not find function "collect"

Do you know what that is?

[andresrcs]

@Slavek

RODBC

RODBC doesn't seem to have a collect() function or at least no longer has one. It must come from another package that you are overlooking or forgetting about. Possible candidates are dbplyr, SparkR