DB2 driver for windows

[Philip]

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

Thanks,
Philip

[Dave Benjamin]

Re: DB2 driver for windows

In article <3f6cc89b$0$112 2$6c56d894@feed 0.news.be.easyn et.net>, Philip wrote:[color=blue]
> i'am looking for a db2 driver for windows
> the DB2 servers runs on as400 if that makes any difference.[/color]

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 :

[Philip]

Re: DB2 driver for windows

Dave Benjamin wrote:
[color=blue]
> In article <3f6cc89b$0$112 2$6c56d894@feed 0.news.be.easyn et.net>, Philip
> wrote:[color=green]
>> i'am looking for a db2 driver for windows
>> the DB2 servers runs on as400 if that makes any difference.[/color]
>
> 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
>[/color]

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

[M.-A. Lemburg]

Re: DB2 driver for windows

Philip wrote:[color=blue]
> Dave Benjamin wrote:
>
>[color=green]
>>In article <3f6cc89b$0$112 2$6c56d894@feed 0.news.be.easyn et.net>, Philip
>>wrote:
>>[color=darkred]
>>>i'am looking for a db2 driver for windows
>>>the DB2 servers runs on as400 if that makes any difference.[/color]
>>
>>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
>>[/color]
>
> 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.[/color]

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

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

--
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source (#1, Sep 23 2003)[color=blue][color=green][color=darkred]
>>> Python/Zope Products & Consulting ... http://www.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/[/color][/color][/color]
_______________ _______________ _______________ _______________ ____________

::: Try mxODBC.Zope.DA for Windows,Linux,S olaris,FreeBSD for free ! ::::

[M.-A. Lemburg]

Re: DB2 driver for windows

M.-A. Lemburg wrote:[color=blue]
> Philip wrote:
>[color=green]
>> Dave Benjamin wrote:
>>[color=darkred]
>>> In article <3f6cc89b$0$112 2$6c56d894@feed 0.news.be.easyn et.net>, 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
>>>[/color]
>>
>> 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.[/color]
>
>
> FYI, mxODBC works fine using the IBM DB2/400 driver for Linux:
>
> http://www-1.ibm.com/servers/eserver...es/linux/odbc/[/color]

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)[color=blue][color=green][color=darkred]
>>> Python/Zope Products & Consulting ... http://www.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/[/color][/color][/color]
_______________ _______________ _______________ _______________ ____________

::: Try mxODBC.Zope.DA for Windows,Linux,S olaris,FreeBSD for free ! ::::

[Jan Csisko]

Re: DB2 driver for windows

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 <SPAMtbone@free gates.be> wrote in message news:<3f6f6c4c$ 0$1115$6c56d894 @feed0.news.be. easynet.net>...[color=blue]
> Dave Benjamin wrote:
>[color=green]
> > In article <3f6cc89b$0$112 2$6c56d894@feed 0.news.be.easyn et.net>, Philip
> > wrote:[color=darkred]
> >> i'am looking for a db2 driver for windows
> >> the DB2 servers runs on as400 if that makes any difference.[/color]
> >
> > 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
> >[/color]
>
> 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[/color]

[Jarek Zgoda]

Re: DB2 driver for windows

M.-A. Lemburg <mal@lemburg.co m> pisze:
[color=blue][color=green]
>> FYI, mxODBC works fine using the IBM DB2/400 driver for Linux:
>>
>> http://www-1.ibm.com/servers/eserver...es/linux/odbc/[/color]
>
> Oops, you were looking for a Windows driver: those work too
> with mxODBC, but I can't give you a URL.[/color]

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:jarek@jabbe rpl.org http://zgoda.jogger.pl/