CODEWITHSUNDEEP
rodbcr-dbi
RockScience
RockScience

Reputation: 18580

DBI or odbc package for SQL server

We are moving away from RODBC which seems to have a limited error handling system (sometimes to query goes through even though there was an error, and there is no way to get the error message. we have tried all RODBC functions)

However there seem to be 2 packages similar: odbc and DBI, Can someone explain what is the difference between the two? Both seem to work well.

Upvotes: 8

Views: 5792

Answers (1)

Alexandre Lima
Alexandre Lima

Reputation: 145

look at the odbc github https://github.com/r-dbi/odbc#reading

They compare with the RSQLServer package and the odbc package seems to be faster.

Upvotes: 1

Related Questions