search

dfe-analytical-services / techskills_workshops

Project outlines for tech skills workshops covering Git/Dev Ops/GitHub, developing reproducible analytical pipelines and working in R and SQL.
4 stars 0 forks source link

More detail for RODBC vs dplyr::tbl syntax and connection setup #17

Closed jen-machin closed 1 month ago

jen-machin commented 7 months ago

The connection setup for both is different and can result in this error. Do we need to explain connection settings in more detail so that people can just copy/paste syntax? Could probably use headings for option 1 and option 2 descriptions too to make them a bit clearer.

jen-machin commented 7 months ago

Look through issues in R workshop docs and decide which to fix

rmbielby commented 3 months ago

RODBC::sqlQuery() lacks a connection set-up, so people are trying to use the DBI connection to run it. Could move the whole RODBC thing to a separate footnote or appendix?