What is the difference between connecting to RDBMS using ODBC and native drivers?
Editorial / Best Answer
Answered by: David W.
ODBC is an open standard for software providers to follow when creating an intermidate layer between the database and the application using the database. Having "open standards" usually means that different applications can write their code the same way no matter which database they are using, as long as that database comes with an ODBC driver.In contrast, native drivers are built with one specific database in mind. Thus, applications written to use the native driver will only work with one particular database. You will lose flexibility in your code's ability to switch database vendors, but you might gain performance enhancements due to the fact that the driver is custom made for the database and may be able to take advantage of an "insider's view" of the database software.
- Step-up transformer power generation
- Opc 43 & 53 cement grades
- Classical and alv report
- Oracle connector stage and Oracle enterprise satge
- Java implementation drive
- Roll back and roll forward
- Identify critical invoice in SAP
- Transformer based ups vs transformer less ups
- Vpn and vlan
- Difference beetween ppc & opc
- Teradata versions
- Ibm install manager and launcher
- Ms SQL server and SQL server
- Change request (cr) and modification
- Nominal ledger
- Filters and restricted columns
- Difference between mobile app testing and mobile app native testing
- Horizontal and vertical clustering
- Mobile and desktop testing
- RMAN logical and physical backup