Menu
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.
615
ODBC is constrained to relational data stores; OLE DB supports all forms of data stores (relational, hierarchical, etc) In general, OLE DB provides a richer and more flexible interface for data access because it is not tightly bound to a command syntax (like SQL in the case of ODBC).
2- OLE DB is more faster than ODBC ... Microsoft ADO, OL DB, and ODBC MDAC Components. Developers can use any of MDAC's components (ODBC, OLE DB, and ADO) to connect to several relational and non-relational data stores.
ODBC is the primary native data access API for applications written in C and C++ for SQL Server. There's an ODBC driver for most data sources. Other languages that can use ODBC include COBOL, Perl, PHP, and Python.
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.
123
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
