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

Hi :-) 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 substitution for ZODB but something more of an import/export feature. I've looked pretty closely on Zope <-> relational database connectivity and I understand t

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

Title: RE: Oracle 9i, Zope 2.9.0 and Windows  Try this http://zope.org/Members/timmorgan/products/ZODBCDA/document_view it's the one I use and it works pretty good, you just have to install also the Mark Hammond's Python Win32 Extensions before, chek this link it has the instructions. I hope

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

[EMAIL PROTECTED] wrote at 2006-4-4 13:08 CES: > ... >I've found the wiki page: >http://zopewiki.org/Oracle >and it seems that DOracle2 would be the best thing for my needs (I only n= >eed simple inserts and querries, nothing really fancy). But as I see ther= >e is no binary for Python 2.4 and Wind

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

I was also hoping someone who uses Windows more than I do would build DCOracle2 for Python 2.4. I agree that one "right" alternative is cx_Oracle. (I'm not familar with Zope's ODBC adapter). To answer a couple of Maciej's questions... Yes, you would still need the Oracle client installed aft

[Zope-DB] ZSQL + MySQL + sqltest + list

Hi, Really frustrated by this. I want catId to be a list: ie [4, 6, 8]. Examples indicate that I can do this. However, ZSQL generates an error every time I put in more than one integer. How can I pass a list of integers? Many thanks. -- Matthew Fairclough ___

[Zope-DB] ZSQL + MySQL + sqltest + list

Hi, Really frustrated by this. I want catId to be a list: ie [4, 6, 8]. Examples indicate that I can do this. However, ZSQL generates an error every time I put in more than one integer. How can I pass a list of integers? Many thanks. -- Matthew Fairclough __

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

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] mysql / zope db connection issue

Hi, I have written a series of zope pages for a person to update their record in our mysql database. They use a zpt->python->db sql->db driver->db flow and work pretty well. Unfortunately, if enough people use it, the number of open db connections grows until it hits a limit and the db stops ac

[Zope-DB] Re: ZSQL + MySQL + sqltest + list

Matthew Fairclough wrote: Hi, Really frustrated by this. I want catId to be a list: ie [4, 6, 8]. Examples indicate that I can do this. However, ZSQL generates an error every time I put in more than one integer. How can I pass a list of integers? Many thanks. -- Matthew Fairclough What