[Zope-DB] How to connect to DB2 on the iSeries via Zope from Windows 2000 or XP

[Breuer, Yvon]

> > Hello to all of the zope-db list,
> >  
> > I am trying to find out how I can connect to the DB2 database on our 
> > iSeries.
> > At http://www.bluedynamics.org/products/ZDB2DA I found a Zope DB2 Database 
> > adapter, a Python DB2 Module and some installation instructions.
> >  
> > Now you probably think "where is your problem? you've got what you want"... 
> > My problem is that the installations instructions on BlueDynamics seem to 
> > be written for Linux. And unfortunately I have no knowledge of Linux (or 
> > any other *NIX) so I can't get things up and running. Maybe one of you can 
> > explain me how to install the Zope DB2 Database Adapter and the Python DB2 
> > Module under Windows 2000 or XP?
> >  
> > Then another question to ZDB2DA and pydb2:
> > To me it seems that there has been not much activity lately. Can anyone > > tell me if it still works with the latest Zope and Python versions?
> >  
> > Thank you in advance for your support!
> 
> You normally have to compile Python database drivers against some source so 
> you will need a C++ compiler. Alternatively you can install cygwin which > allows you to run Un*x programs under Windows but this usually isn't the > ideal solution.
> 
> This a problem for many Python drivers because it is a lot of work keeping up 
> with different DB versions and Python / OS combinations. Do you know whether 
> your database has been configured to work with an ODBC manager? If this is 
> the case then you would be able to use our mxODBCZopeDA for the connection.
> 
> Charlie

Thank you Charlie for replying, but I generally prefer completely free (non-commercial) products. Besides of that I assume that a specific ZDB2DA will be faster than any ZODBCDA. (Convince me if that assumption is wrong.) And if I have to chose for ODBC in the end, I'm sorry but then there are other non-commercial DA's available which I would like to give a try first.

About cygwin:
Installing cygwin does indeed not sound like a 'neat' solution. ;-)

About the C++ compiler:
I have no C++ compiler available. And even then, how should I compile it? I'm not familiar with C++.

It wonders me that it seems to be so complicated. When I search over the internet for an answer I can find quite some similar questions from others but no good answer so far. I just can't believe it hasn't been done before from Windows 2000 or XP.

More help is appreciated. :-)


**********************************************************************
CONFIDENTIALITY DISCLAIMER

The information in this email and in any attachments is confidential and may be 
privileged.  If you are not the intended recipient, please destroy this message,
 delete any copies held on your systems and notify the sender immediately.
  
You should not retain, copy or use this email for any purpose outside of any NDA
currently existing between Toshiba Electronics Europe GmbH and yourselves.
**********************************************************************