Re: [Zope-DB] Multiple databases connection

2006-06-09 Thread Infor Gates
r method which will return the name of the database connection to use allowing you to dynamically change the DB connection.AOn 9 Jun 2006, at 06:19, Infor Gates wrote:> My apologies if my query is unclear.> M.Banaouas got it right. Let try to explain it another way:> 1. We have a

[Zope-DB] Multiple databases connection

2006-06-08 Thread Infor Gates
My apologies if my query is unclear. M.Banaouas got it right. Let try to explain it another way:1. We have a standard Zope application which is replicated in ZMI.2. the difference in each Zope application is DBconnection.3. Each DBconnection is connection to each Branch database.In other words, if

[Zope-DB] Multiple databases connection

2006-06-07 Thread Infor Gates
Dear listMy organisation received databases uploaded from our branches. These branches databases are then restored into the main system. The Main Office then access to these databases individually.Currently, separate copies of the same zope application is copied in the same Zope server correspondin

[Zope-DB] Help request from a non-developer

2006-04-15 Thread Infor Gates
I hope this can help you.|Thanks for responding. Well, I choose this list because I thought|(without extensive Zope knowledge) a possible solution would be to use|an external DB, like MySQL for example, on a separate server for all|client data and only use the ZoDB for site/programming related data

[Zope-DB] Oracle 9i, Zope 2.9.0 and Windows

2006-04-04 Thread Infor Gates
You can use www.egenix.com for connection to Oracle ortry Postgresql 8.x.  Postgresql can run natively on WIndows XP Pro. The adapter is available from www.initd.org. CY|I'm doing a commercial project on Zope 2.9.0 in which I have to read |and write data to Oracle 9.2.0.4 database. It won't be a su

[Zope-DB] Re: Antwort: Re: 1. help appreciated [Virus checked]

2006-01-13 Thread Infor Gates
Hv u try using the ZSearchInterface calling your ZSQL method (below). Try it. It will solve your problem except the layout is not good looking.  Hiowever, you may to modify it to pass arguments to your ZSQL method. Look for:          (Previous results)   ;    

[Zope-DB] 1. help appreciated

2006-01-12 Thread Infor Gates
Please check Control Panel/Product Management. If the ZSQLMethods is shown as broken, looks your ocde broke it.Wonder why you need to change the ZSQLMet;hod?CY|I tried some changes in "opt/Zope-2.8/lib/python/Shared/DC/ZRDB" which|worked fine.|But then these Objects all appreared like this:|Abrechn

[Zope-DB] Re: ZPyscopgDA for Windows XP

2005-05-30 Thread Infor Gates
My apologies. Actually, you are receiving resend of an earlier email when I received a rejected reply from the mail host server. I have downloaded psycopg-2.0b2-win32-py23.exe. python2.3 (windows versin) and Zope2.7.6 (windows binaries). I had installed it. However, I had this error message - MSV

Re: [Zope-DB] ZPyscopgDA for Windows XP

2005-05-27 Thread Infor Gates
> > On 2005-05-27 at 12:52:05 [+0200], Infor Gates > <[EMAIL PROTECTED]> wrote: > > Dear Zopists > > > > I am looking for ZPyscopgDA that works with > Postgresql > > 8.0.3 on Windows. Can anyone point me to the URL? > > > > I found an old v

[Zope-DB] ZPyscopgDA for Windows XP

2005-05-27 Thread Infor Gates
Dear Zopists I am looking for ZPyscopgDA that works with Postgresql 8.0.3 on Windows. Can anyone point me to the URL? I found an old version ZPyscopgDA ver 1.0.12 for window binaries. However, it does not work with Postgresql 8.0.3. My Zope version is 2.6.4. Error message: psycopg.OperationalE

[Zope-DB] Python Script / ZSQL

2005-05-10 Thread Infor Gates
Hello Zopist I am new and try to learn python script with ZSQL in Zope. I have read the Zope Book. However, most of them are in DTML and very few on python script. I have a little knowledge on Zope and SQL but am lost in trying to see the whole picture of zope/pythonscript/zsql. I have a simple d