Python ODBC

[Harlin Seritt]

Is there a Python odbc module that will work on Linux? I have a jdbc
connection to a DB2 server. I am looking hopefully for an open source
solution and not a commercial one.

Thanks,

Harlin

 

[Harry George]

I would think the odbc module would work. We've used SQLRelay here at
work too. Here's a link on the database modules for Python:

http://www.python.org/topics/database/modules.html

And here's a few links on db2 with Python:

http://www-128.ibm.com/developerwor...inux/db2proj/updated/python_db2_interface.htm
http://sourceforge.net/projects/pydb2/
http://www-128.ibm.com/developerworks/edu/i-dw-db2pylnx-i.html

Hope that helps.

Mike

I've looked into it, but never got all the
way to a solution. As I understand it:

1. The DBMS needs to support ODBC. DB2 does, so ok.

2. You need a client side framework and driver. Those are provided on
MS Win platforms. On *NIX platforms, unixodbc and iodbc are the
main players.

http://www.unixodbc.org/
http://www.iodbc.org/

3. For *NIX you need python bindings. This is where mxODBC has
operated (e.g., with iodbc). But there is an OSS effort at:
https://sourceforge.net/projects/pyodb

 

[kyosohma]

Is there a Python odbc module that will work on Linux? I have a jdbc
connection to a DB2 server. I am looking hopefully for an open source
solution and not a commercial one.

Thanks,

Harlin

I would think the odbc module would work. We've used SQLRelay here at
work too. Here's a link on the database modules for Python:

http://www.python.org/topics/database/modules.html

And here's a few links on db2 with Python:

http://www-128.ibm.com/developerwor...inux/db2proj/updated/python_db2_interface.htm
http://sourceforge.net/projects/pydb2/
http://www-128.ibm.com/developerworks/edu/i-dw-db2pylnx-i.html

Hope that helps.

Mike