[R] get data frame using DBI package

Jeff Newmiller jdnewm|| @end|ng |rom dcn@d@v|@@c@@u@
Fri Jul 2 00:49:31 CEST 2021


Please make the effort to post plain text email... formatted email gets stripped and what remains is often garbled.

Most people use dbGetQuery... but reading the help page accessible via ?dbSendQuery should clarify how it should be used.

On July 1, 2021 3:36:46 PM PDT, Kai Yang via R-help <r-help using r-project.org> wrote:
>Hi List,I use odbc to connect a MSSQL server. When I run the script of
>"res <- dbSendQuery(con, "SELECT * FROM BIODBX.MECCUNIQUE2")", the res
>is "Formal class OdbcResult". Can someone help me to modify the code to
>get a data frame?Thanks,Kai
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.

-- 
Sent from my phone. Please excuse my brevity.



More information about the R-help mailing list