Menu
Recently Zed Shaw (a programmer who blogs) mentioned that ODBC references should be removed from the popular python book Dive into Python. I have never worked with ODBC and I just wanted to understand why ODBC is so "bad". What are the pros and cons of the technology? What alternatives are there?
608
Severs not standardized: In ODBC since most of the work is done by clients, it is difficult to scale. In addition to this in ODBC driver servers are not sufficiently standardized. Therefore, clients maintain their own drivers, naming tables, and macros, which complicates management at larger sites.
ODBC remains in wide use today, with drivers available for most platforms and most databases.
Open Database Connectivity (ODBC) is an open standard application programming interface (API) that allows application programmers to access any database.
Professional design standards: ODBC is unparalleled when it comes to reliability, scalability, performance & security powering as a leading data integration solution.
The biggest issue is that 64 Bit support is not entirely available across different data sources. Another problem is that people often bridge ODBC from another technology where they could simply eliminate the unnecessary layers of complexity. For example, JDBC->ODBC when they could simply go JDBC direct.
114
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
