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

DB2 driver for windows

P: n/a
Hi,
i'am looking for a db2 driver for windows
the DB2 servers runs on as400 if that makes any difference.

Thanks,
Philip
Jul 18 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
In article <3f**********************@feed0.news.be.easynet.ne t>, Philip wrote:
i'am looking for a db2 driver for windows
the DB2 servers runs on as400 if that makes any difference.


I don't know if you're looking for a native driver, but if you can work with
ODBC, I was able to get DB2's ODBC driver (the one that comes with the DB2
client installation) to talk to the mx.ODBC module.

http://www.egenix.com/files/python/mxODBC.html

--
..:[ dave benjamin (ramenboy) -:- www.ramenfest.com -:- www.3dex.com ]:.
: d r i n k i n g l i f e o u t o f t h e c o n t a i n e r :
Jul 18 '05 #2

P: n/a
Dave Benjamin wrote:
In article <3f**********************@feed0.news.be.easynet.ne t>, Philip
wrote:
i'am looking for a db2 driver for windows
the DB2 servers runs on as400 if that makes any difference.


I don't know if you're looking for a native driver, but if you can work
with ODBC, I was able to get DB2's ODBC driver (the one that comes with
the DB2 client installation) to talk to the mx.ODBC module.

http://www.egenix.com/files/python/mxODBC.html


Currently i'am using jython for database administration (because didn't find
an native driver)

I like the java jdbc driver because you don't need to install anything
especialy interesting when sharing code)

But the downside is that you have the java tiresome api. the obvious reason
way i have choicen python/jython.

Well, prefer a native one but if it's easy to install the odbc driver
that would be fine too.

Thanks,
Philip

Jul 18 '05 #3

P: n/a
Philip wrote:
Dave Benjamin wrote:

In article <3f**********************@feed0.news.be.easynet.ne t>, Philip
wrote:
i'am looking for a db2 driver for windows
the DB2 servers runs on as400 if that makes any difference.


I don't know if you're looking for a native driver, but if you can work
with ODBC, I was able to get DB2's ODBC driver (the one that comes with
the DB2 client installation) to talk to the mx.ODBC module.

http://www.egenix.com/files/python/mxODBC.html


Currently i'am using jython for database administration (because didn't find
an native driver)

I like the java jdbc driver because you don't need to install anything
especialy interesting when sharing code)

But the downside is that you have the java tiresome api. the obvious reason
way i have choicen python/jython.

Well, prefer a native one but if it's easy to install the odbc driver
that would be fine too.


FYI, mxODBC works fine using the IBM DB2/400 driver for Linux:

http://www-1.ibm.com/servers/eserver...es/linux/odbc/

--
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source (#1, Sep 23 2003)
Python/Zope Products & Consulting ... http://www.egenix.com/
mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/

__________________________________________________ ______________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
Jul 18 '05 #4

P: n/a
M.-A. Lemburg wrote:
Philip wrote:
Dave Benjamin wrote:
In article <3f**********************@feed0.news.be.easynet.ne t>, Philip
wrote:

i'am looking for a db2 driver for windows
the DB2 servers runs on as400 if that makes any difference.

I don't know if you're looking for a native driver, but if you can work
with ODBC, I was able to get DB2's ODBC driver (the one that comes with
the DB2 client installation) to talk to the mx.ODBC module.

http://www.egenix.com/files/python/mxODBC.html


Currently i'am using jython for database administration (because
didn't find
an native driver)

I like the java jdbc driver because you don't need to install anything
especialy interesting when sharing code)

But the downside is that you have the java tiresome api. the obvious
reason
way i have choicen python/jython.

Well, prefer a native one but if it's easy to install the odbc driver
that would be fine too.

FYI, mxODBC works fine using the IBM DB2/400 driver for Linux:

http://www-1.ibm.com/servers/eserver...es/linux/odbc/


Oops, you were looking for a Windows driver: those work too
with mxODBC, but I can't give you a URL.

Known issues with the driver:

* Make sure that you switch off connection pooling in the MS ODBC
manager if your are using multiple connections to the database
in a single app.

* The DB2 ODBC Driver for NT has an optimization option called
early cursor close (or similar). This has to be switched off.
Otherwise, you'll get lots of SQLSTATE 08001 or 080003 errors
during connects and parallel execution of commands becomes
impossible.

--
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source (#1, Sep 23 2003)
Python/Zope Products & Consulting ... http://www.egenix.com/
mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/

__________________________________________________ ______________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
Jul 18 '05 #5

P: n/a
Hi Philip,

please note that the Drivers available at http://www.openlinksw.com
will provide you with JDBC as well as ODBC access to DB2 from almost
any OS.

Hth,
Regards,
Jan
Philip <SP*******@freegates.be> wrote in message news:<3f**********************@feed0.news.be.easyn et.net>...
Dave Benjamin wrote:
In article <3f**********************@feed0.news.be.easynet.ne t>, Philip
wrote:
i'am looking for a db2 driver for windows
the DB2 servers runs on as400 if that makes any difference.


I don't know if you're looking for a native driver, but if you can work
with ODBC, I was able to get DB2's ODBC driver (the one that comes with
the DB2 client installation) to talk to the mx.ODBC module.

http://www.egenix.com/files/python/mxODBC.html


Currently i'am using jython for database administration (because didn't find
an native driver)

I like the java jdbc driver because you don't need to install anything
especialy interesting when sharing code)

But the downside is that you have the java tiresome api. the obvious reason
way i have choicen python/jython.

Well, prefer a native one but if it's easy to install the odbc driver
that would be fine too.

Thanks,
Philip

Jul 18 '05 #6

P: n/a
M.-A. Lemburg <ma*@lemburg.com> pisze:
FYI, mxODBC works fine using the IBM DB2/400 driver for Linux:

http://www-1.ibm.com/servers/eserver...es/linux/odbc/


Oops, you were looking for a Windows driver: those work too
with mxODBC, but I can't give you a URL.


There's no URL. Windows ODBC driver for DB2/400 is part of ClientAccess
Express suite and is not available separately.

--
Jarek Zgoda
Registered Linux User #-1
http://www.zgoda.biz/ JID:ja***@jabberpl.org http://zgoda.jogger.pl/
Jul 18 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.