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?
+1
A:
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.
Nissan Fan
2010-04-27 19:50:15
A:
ODBC is the only way I've found to access a Solid DB Server from Python.
If you have no other choice, it could be a life saver.
dugres
2010-04-28 09:12:27