Displaying 5 results from an estimated 5 matches for "rodbcext".
2017 Sep 12
3
Unable to load packages RODBC and RODBCext in R
Dear all,
Hope you are doing great. I am currently using R version 3.4.1 ("Single
Candle") and was trying to install packages RODBC and RODBCext using the
following steps:
> install.packages("RODBCext")
Installing package into ?C:/Users/PaulBernal/Documents/R/win-library/3.4?
(as ?lib? is unspecified)
also installing the dependency ?RODBC?
trying URL '
https://mirrors.dotsrc.org/cran/bin/windows/contrib/3.4/RODBC_1.3-15.z...
2017 Sep 12
0
Unable to load packages RODBC and RODBCext in R
...in his "Bloom County" comic strip )
On Tue, Sep 12, 2017 at 8:17 AM, Paul Bernal <paulbernal07 at gmail.com> wrote:
> Dear all,
>
> Hope you are doing great. I am currently using R version 3.4.1 ("Single
> Candle") and was trying to install packages RODBC and RODBCext using the
> following steps:
>
> > install.packages("RODBCext")
> Installing package into ?C:/Users/PaulBernal/Documents/R/win-library/3.4?
> (as ?lib? is unspecified)
> also installing the dependency ?RODBC?
>
> trying URL '
> https://mirrors.dotsrc.org/...
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
...;
> append=TRUE,
>
> addPK=TRUE,
>
> fast=TRUE)
>
>
>
> # http://stackoverflow.com/questions/36202414/r-download-image-using-rvest
>
> # https://www.r-bloggers.com/parameterized-sql-queries/
>
> # https://cran.r-project.org/web/packages/RODBCext/
> vignettes/Parameterized_SQL_queries.html
>
>
>
> library(RODBCext)
>
> filterData <- data.frame('cosa'= c('libros'))
>
> data <- sqlExecute(cn, "SELECT * FROM prueba WHERE cosa = ?", filterData,
> fetch = TRUE)
>
> if(length(dat...
2017 Jul 12
2
consulta por varTypes de sqlSave en RODBC
Buen dia compañerxs de R, les traigo una pregunta bastante especifica.
En el trabajo me estan requiriendo el uso de SQL, asi q estoy aprendiendo a
usarlo desde R, con el paquete RODBC.
Mi problema puntual es que al crear una tabla en el servidor SQL a partir
de un data frame en R (usando la funcion sqlSave) no puedo definir el tipo
de variables que quiero usar en el data frame.
Segun entiendo
2017 Jul 13
2
consulta por varTypes de sqlSave en RODBC
...;
> append=TRUE,
>
> addPK=TRUE,
>
> fast=TRUE)
>
>
>
> # http://stackoverflow.com/questions/36202414/r-download-image-using-rvest
>
> # https://www.r-bloggers.com/parameterized-sql-queries/
>
> # https://cran.r-project.org/web/packages/RODBCext/
> vignettes/Parameterized_SQL_queries.html
>
>
>
> library(RODBCext)
>
> filterData <- data.frame('cosa'= c('libros'))
>
> data <- sqlExecute(cn, "SELECT * FROM prueba WHERE cosa = ?", filterData,
> fetch = TRUE)
>
> if(length(dat...