By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,772 Members | 935 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,772 IT Pros & Developers. It's quick & easy.

Python ODBC

P: n/a
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

Apr 29 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Apr 29, 11:34 am, Harlin Seritt <harlinser...@yahoo.comwrote:
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/developerwork..._interface.htm
http://sourceforge.net/projects/pydb2/
http://www-128.ibm.com/developerwork...b2pylnx-i.html

Hope that helps.

Mike

Apr 30 '07 #2

P: n/a
ky******@gmail.com writes:
On Apr 29, 11:34 am, Harlin Seritt <harlinser...@yahoo.comwrote:
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/developerwork..._interface.htm
http://sourceforge.net/projects/pydb2/
http://www-128.ibm.com/developerwork...b2pylnx-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

--
Harry George
PLM Engineering Architecture
Apr 30 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.