Le 22 janv. 2007, à 20:12, Mário Valente a écrit :
OK, I'm now using DB2 on the portuguese
Ministry of Justice mainframe, running on z/OS.
Can you help with the original problem/question?
This is much tougher. The only solution I've heard of is the following:
Assuming IBM does provide an ODBC driver for the platform you run CPS
on (don't know about z/OS, the iSeries version is the only one I used),
then you can configure an ODBC driver manager and access the driver
manager through egenix' Zope mxODBC DA's adapter. You should end up
with a connector object to which you can bind a CPS SQLDirectory. You
should perhaps experiment this last part with something easier, like
the one Florent suggested, or postgresql with
http://wiki.zope.org/zope2/ZPsycopgDA.
Remarks:
- if you have no experience in the ODBC world, try and have someone
who does help you for this part. Error codes are completely obscure
(google is your friend but you have to be patient)
- I didn't try the Zope DA adapter, and relied instead on pure mxODBC
python library, since my needs were somewhat simpler (vocabularies
extracted from the DB). Both are commercial products (per Zope instance
licence for the former)
- the iSeries access ODBC driver comes with a version of unixODBC. I
could'nt get mxODBC to hook to iODBC in that context, but had success
with unixODBC, after I had upgraded the provided one to a more recent
version.
- don't forget to configure the charset.
Thanks.
Well, lots of work, good luck !
PS: check egenix and unixODBC mailing-lists, as obviously ODBC
discussions don't belong here.
-- MV
-----Mensagem original-----
De: Florent Guillaume [mailto:[EMAIL PROTECTED]
Enviada: sábado, 20 de Janeiro de 2007 21:27
Para: Mário Valente
Cc: [email protected]
Assunto: Re: [CPS-users] Adding contacts database
On 17 Jan 2007, at 14:49, Mário Valente wrote:
On 1/12/07, Mário Valente <[EMAIL PROTECTED]> wrote:
Right. Why should I need an aditional piece of software to
manage?
Well, if you want to store it in an SQL database, then you need an
SQL database to store it in.
Thats why I'm using Gadfly. Within Zope.
Please be aware that Gadly is a "toy" database, putting things in
memory, without concurrency and with very limited SQL support compared
to the standard. And it's slow. Its only advantaged is that it's only
coded in python so doesn't require any external setup.
You'd be better off using at least sqlite, which is "light" but much
more serious and efficient.
There's a Zope DA for it (untested by ourselves), http://www.zope.org/
Members/nakagami/ZSQLiteDA
Florent
--
Florent Guillaume, Director of R&D, Nuxeo Open Source Enterprise
Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
cps-users mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/cps-users
_______________________________________________
cps-users mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/cps-users
