thr3ads.net - R help - [R] get data frame using DBI package [Jul 2021]

If this information is useful, please help other people find it:
Share via:

Kai Yang

2021-Jul-01 22:36 UTC

[R] get data frame using DBI package

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]]

Jeff Newmiller

2021-Jul-01 22:49 UTC

head link

[R] get data frame using DBI package

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 at
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 at 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.

R help - Jul 2021 - get data frame using DBI package

[R] get data frame using DBI package

[R] get data frame using DBI package