Re: [Fwd: Re: [Zope-DB] Status and future of OracleStorage]

2005-03-30 Thread Dieter Maurer
Tim Peters wrote at 2005-3-28 14:09 -0500: [Shane Hathaway] Ape works just fine, so it doesn't need us much maintenance as it used to. The storage comparison chart is out of date--it's no longer in alpha. Feel free to check in updates on Zope-2_7-branch:

Re: [Zope-DB] ZODB/ZEO question.

2005-04-04 Thread Dieter Maurer
Willadsens wrote at 2005-4-3 19:10 -0400: ... Correct, and very intentional. The current question is: semaphore or trap error and retry? The standard way is to catch the ConflictError, abort the transaction and then retry the transaction. Of course, you can try to serialize your transactions.

Re: [Zope-DB] DCOralcle2 Invalid connection string

2005-04-06 Thread Dieter Maurer
Federica Gomiero wrote at 2005-4-6 17:23 +0200: ... Invalid connection string: user_name/[EMAIL PROTECTED] with this error.log: Traceback (innermost last): ... Module Products.ZOracleDA.DCOracle2.DCOracle2, line 185, in connect BadRequest: strongInvalid connection string:

Re: [Zope-DB] MySQL ZSQL Transactions or Commit in Zope?

2005-05-17 Thread Dieter Maurer
Michael Schwartz wrote at 2005-5-15 16:30 -0400: I am trying to find sample code for performing transactions in ZSQL with mysql 4.1. I'd like to do something like this: 1 - Insert record A into USER table 2 - Get auto_increment id for record A 3 - Insert record B into WIDGET table with

Re: [Zope-DB] DCoracle2 - truncates UTF-8 string with national characters

2005-05-23 Thread Dieter Maurer
Maciej Wi-Bniowski wrote at 2005-5-23 14:54 +0200:-A We're using DCOracle2 with Zope. On the client machine I've NLS_LANG = polish_poland.UTF8. The problem appears when I'have 30 characters long column in database, and the text stored in this column contains national characters and is full

Re: [Zope-DB] Zope 2.8 and DCOracle2 Stored Procedures

2005-06-23 Thread Dieter Maurer
Maciej Wisniowski wrote at 2005-6-23 10:28 +0200: ... Module Products.DCOracle2.SP, line 301, in __call__ TypeError: unbound method _lobConvert() must be called with DB instance as first argument (got list instance instead) On Zope 2.7.x everything is OK. Any ideas what is wrong?? Look at line

Re: [Zope-DB] Using psycopg directly in Zope Python script

2005-07-03 Thread Dieter Maurer
Jørgen Frøjk Kjærsgaard wrote at 2005-7-1 23:28 +0200: I need to be able to access a Postgresql database directly from Zope Python scripts (Z SQL Methods is not an option as the SQL code occurs in modules that must be re-usable in a non-Zope context). ... import psycopg dbcon =

Calling function with variable arguments from ZPublisher (was: Re: [Zope-DB] Using psycopg directly in Zope Python script)

2005-07-04 Thread Dieter Maurer
Jørgen Frøjk Kjærsgaard wrote at 2005-7-4 11:04 +0200: ... Another question: When I define an external method to process form data, I have to do it like this: def process_form_data(self, name, address, zip, ...): ... What I would like to do is: def process_form_data(self, **args): ...

Re: [Zope-DB] Deleting a ZCatalog Object from ZODB

2005-07-08 Thread Dieter Maurer
Takahashi, Michael wrote at 2005-7-7 09:27 -0700: But there must be another more efficient way to delete just the single object in the ZCatalog. Indeed: If you look at the catalog API (e.g. in the source or via DocFinder), you will find the uncatalog_object method. -- Dieter

Re: [Zope-DB] psycopg + zope problem

2005-09-07 Thread Dieter Maurer
Martin Konicek wrote at 2005-9-7 17:26 +0200: ... * ls /var/lib/zope/lib/python/Products/ZPsycopgDA/ [ ...output ommited...] Provided that Zope looks there for its products, you should see any problems with the import of ZPsycopgDA in your Zope logfile. I cannot tell you where the Zope

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-20 Thread Dieter Maurer
Germer, Carsten wrote at 2005-10-20 11:16 +0200: ... As we start to use our zope-Ora connection more frequently our database administrator complains that he sees a lot of idle conections. I know theres connection.close() in DCOra2 but does anyone know of a way to autmatically close a DCOra

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Dieter Maurer
Chris Withers wrote at 2005-10-21 16:27 +0100: ... Well, it depends, there can be a need for lots of infrequently used DA's connecting to the same database. What prevents to replace these DA's by a single instance? Looks much easier than a sophisticated connection pool management... Having

RE: [Zope-DB] Closing idle DCoracle2 Connections?

2005-11-02 Thread Dieter Maurer
Germer, Carsten wrote at 2005-10-24 13:32 +0200: Ok, that's a bit much for my question I guess... I gather from all your mails that I can not close a database connection periodically or on event from Zope (Script or whatever)? Modulo bugs, this happens automatically (when the DA object is flushed

Re: [Zope-DB] DCOracle2 for Python2.4

2005-11-18 Thread Dieter Maurer
Matthew Cahn wrote at 2005-11-16 13:02 -0500: I have an application which uses DCOracle2. I wonder if anyone has built dco2.pyd for Python 2.4. The 2.3 version built by Mikey at Zope has been working great. You can use the extension build for Python 2.3 for Python 2.4, too. But version are

Re: [Zope-DB] Getting a newly created record

2005-11-18 Thread Dieter Maurer
Sean Fulmer wrote at 2005-11-17 17:04 +: How can I insert a new record and have the new record immediately returned to me as an object? You must use database means for this. If your database system supports the sequence datatype (and you use it to generate a unique id) then you can use the

Re: [Zope-DB] insert failing without raising exception: postgresql, psycopg

2005-11-22 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2005-11-22 03:27 -0800: Problem: Database inserts that worked previously are now failing, without raising exceptions! I expect that something in your application catches exceptions. To verify this, I would add logging to ZPsycopgDA (indeed, I did in our

Re: [Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

2005-11-30 Thread Dieter Maurer
Kevin Monceaux wrote at 2005-11-29 13:20 -0600: I'm new to Zope so forgive me if the answer to this question is obvious. If one performs a select with a limit clause is it possible to determine how many results would have been returned if there was no limit? For example, if I wanted to select

Re: [Zope-DB] can't Show More than 20 records

2005-12-29 Thread Dieter Maurer
Rajesh wrote at 2005-12-29 13:37 +0530: 1. can not show more than 20 records (Roman Page) ... KeyError: 'query' Traceback (innermost last): A bug which should be fixed in quite recent Zope versions -- Dieter ___ Zope-DB mailing list

Re: [Fwd: Re: [Zope-DB] database connection]

2006-01-13 Thread Dieter Maurer
Martin Krallinger wrote at 2006-1-10 16:57 +0100: thanks for the info. I am actually using zope 2.7 but still I encountered this problem. I think the poster wrote: fixed in Zope 2.7. Maybe, you try 2.8.5 or 2.9? -- Dieter ___ Zope-DB mailing list

Re: [Zope-DB] help appreciated [Virus checked]

2006-01-13 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-1-12 15:03 +0100: After creating about 20 ZSQL Methods and polishing them out, 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: Abrechnung (This object from the ZSQLMethods product is

Re: [Zope-DB] regarding zope database

2006-01-30 Thread Dieter Maurer
-bhavana - [EMAIL PROTECTED] wrote at 2006-1-30 10:27 +0700: ... How to communicate with zope database? You use Zope (or scripts using the Zope codebase). the documents that we post in Plone have id, ya? There are lots of ids around. The id used in Plone is not a universal id, but unique

Re: [Zope-DB] external ZODB from Zope interface

2006-02-02 Thread Dieter Maurer
gyro funch wrote at 2006-2-2 04:34 -0800: I am a Zope newbie with some Python experience. We have a large amount of scientific data that we are planning to load into several ZODBs. From the Zope interface, how can I access these 'external' databases? To access additional storages, you use

Re: [Zope-DB] How I can connect MySQL database?

2006-02-09 Thread Dieter Maurer
G E R R I T wrote at 2006-2-9 10:01 +0800: How I can connect MySQL database from my zope web project? Read the relevant chapter in the Zope Book (2.7 editon, online). BTW: Why to you attach an image when you post to a technical newsgroup? -- Dieter

Re: [Zope-DB] zope 2.8 with MySQL 5.0 extended passwords [Virus checked]

2006-03-02 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-3-2 16:18 +0100: After upgrading the passwords in an 5.0 MySQL database, zope 2.8 cannot reconnect, because the client parts of mysql changed. After changing all my C(++) clients (by using the updated include and libs) all if fine, but the ZOPE stuff. Obviously,

Re: [Zope-DB] zope 2.8 with MySQL 5.0 extended passwords

2006-03-03 Thread Dieter Maurer
Please always stay on the list! Never send questions to me privately (usually, I do not answer them!). List readded... [EMAIL PROTECTED] wrote at 2006-3-3 09:00 +0100: which means recompiling exactly what ??? The Python MySQL adapter is usually called MySQL-python-versionno. Sources can be

Re: [Zope-DB] DCOracle2 on AIX5.2 -- issues

2006-03-14 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-3-13 13:32 -0500: ... However, during compilation of cdo2.o, I did encounter these symptoms: cc_r -DNDEBUG -O -I/oracle/product/ -I/oracle/product/ -I/oracle/product/ /plsql/public

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

2006-04-04 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2006-4-4 13:08 CES: ... I've found the wiki page: 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 Windows.

Re: [Zope-DB] mysql / zope db connection issue

2006-04-05 Thread Dieter Maurer
Jamie O'Keefe wrote at 2006-4-5 01:32 -0400: 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

Re: [Zope-DB] mysql / zope db connection issue

2006-04-06 Thread Dieter Maurer
Jamie O'Keefe wrote at 2006-4-5 13:54 -0400: ... What version of MySQL are you using? An old one... We switched to Postgres, MySQL is used only for legacy components. -- Dieter ___ Zope-DB mailing list

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

2006-04-14 Thread Dieter Maurer
Christophe Appell wrote at 2006-4-14 17:43 +0200: On 4/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Well, this is one reason that I strongly prefer keeping my code on the file system. The availability of change-control software is the other. I happen to like git. Well, we are probably

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-02 Thread Dieter Maurer
Michael Mauws wrote at 2006-5-1 19:02 -0600: ... However, the problem I'm having is that it's not just the update request that hangs. Rather, it's the whole Zope that hangs until this one request has been satisfied. Even Zope requests that have nothing to do with Oracle? This would indicate

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-03 Thread Dieter Maurer
Please always stay on the list! Michael Mauws wrote at 2006-5-2 14:39 -0600: ... In light of the above, I don't think it's a GIL problem (without having a clue what a GIL actually is) This is the Global Interpreter Lock. It prevents more than a single thread to run Python code at the same time.

Re: [Fwd: Re: [Zope-DB] Multiple databases connection]

2006-06-08 Thread Dieter Maurer
Andreas Jung wrote at 2006-6-8 10:12 +0200: ... I am pretty sure you can do it with little coding. Since the DA (or its ID is just a property or attribute (check the implemenation) you should be able to modify it. And someone already did this: he had implemented a special Z SQL Method class

Re: [Zope-DB] Operation Error : Using Zope2.6.1 and mxODBCZopeDA

2006-06-21 Thread Dieter Maurer
Sudesh Soni wrote at 2006-6-21 18:13 +0530: I get the below error : OperationalError on Products.mxODBCZopeDA.ZopeDA.DatabaseConnection DSN=Zope thread 2476/2476 at 0x27150c4: ('08S01', 11, '[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network

Re: [Zope-DB] Operation Error : Using Zope2.6.1 and mxODBCZopeDA

2006-06-22 Thread Dieter Maurer
Sudesh Soni wrote at 2006-6-22 10:39 +0530: ... Yes , i have SonicWall VPN Client version running on our SQL server. If this is the reason then, do i have to make some changes in the settings/properties in Sonic wall ? Usually, firewalls have an option to configure how long the

Re: [Zope-DB] Properly quoting string in ZSQLMethod for Postgresql (psycopg2)

2006-08-09 Thread Dieter Maurer
Maciej Zi-Bęba wrote at 2006-8-9 12:53 +0200:-A I need to insert a python string into Postgresql's text field. I'm using a ZSQLMethod with ZPsycopgDA and the template looks like this: 'INSERT INTO records (zope_id, title, long_description) VALUES (dtml-sqlvar zope_id type=string, dtml-sqlvar

Re: [Zope-DB] Some help about introductory Zope concepts.

2006-09-07 Thread Dieter Maurer
Jose Carlos Balderas Alberico wrote at 2006-9-6 08:42 +0200: I've been reading documentation for a month, and although I think I understand what Zope is used for, there's still something I can't embrace, which is Zope's interaction with Apache. Please read the virtual hosting section in the

Re: [Zope-DB] Zope database connectivity

2006-09-21 Thread Dieter Maurer
M.-A. Lemburg wrote at 2006-9-20 23:00 +0200: ... I'll correct that slightly: Zope DAs usually open the connection as soon as the connection object is loaded into memory, e.g. if you look at the folder contents containing the connection object. In my view, this is a bug in Zope's DA code.

Re: [Zope-DB] Zope database connectivity

2006-09-22 Thread Dieter Maurer
Chris Withers wrote at 2006-9-22 10:48 +0100: Dieter Maurer wrote: M.-A. Lemburg wrote at 2006-9-20 23:00 +0200: ... I'll correct that slightly: Zope DAs usually open the connection as soon as the connection object is loaded into memory, e.g. if you look at the folder contents containing

Re: [Zope-DB] Zope database connectivity

2006-09-24 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-23 00:27 +0200: You could recode DA's to close the connection at the end of every transaction and reopen them on demand, Seems for me that difference betwen connect on load and connect on demand is in _begin, _finish and __init__ methods of TransactionManager

Re: [Zope-DB] Zope database connectivity

2006-09-25 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-24 22:00 +0200: ... Do you have 'connect_' defined elsewhere or it is expected to raise an exception here and just log this? Sure, I have defined connect_. It uses a private ZODB extension to prevent _v_ attributes to be lost mid transaction (which can have

Re: [Zope-DB] KeyError from Shared.DC.DA.DA

2006-09-25 Thread Dieter Maurer
FAIRS, Dan, GBM wrote at 2006-9-25 08:58 +0100: ... Here's the salient part of the traceback: File /opt/intranet/cbfmnet/zope_home/Products/Membership/, line 118, in _getDBValue values = self._getDBValues(attributes=[attribute]) File

Re: [Zope-DB] Zope database connectivity

2006-09-26 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-25 20:09 +0200: It uses a private ZODB extension to prevent _v_ attributes to be lost mid transaction (which can have nasty, partly non deterministic and very difficult to understand effects) and then calls connect. Does this mean that there is a bug in ZODB?

Re: [Zope-DB] Zope database connectivity

2006-09-27 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-27 17:49 +0200: ... Thanks again for explanations. Seems that I'll change my DA's (DCOracle2 and ZCxOracleDA) to use connection pool like psycopg does. After quick look at their (psycopg) solution I think it is really good and solves (or may solve) few other

Re: [Zope-DB] Zope database connectivity

2006-09-28 Thread Dieter . Maurer
Maciej Wisniowski wrote at 2006-9-27 21:38 +0200: ... To be able to finish whole transaction for the relational DB... No. There are two reasons: 1. that later operations see the effects of earlier operations in the same request and more importantly 2. to avoid deadlocks.

Re: [Zope-DB] Zope database connectivity

2006-09-28 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-27 22:40 +0200: ... It can lead to nasty, apparently non-deterministic effects. You may lose your database connection mid transaction and part of what you think is a transaction (i.e. atomical) can be lost. What are the circumstances under which this

Re: [Zope-DB] Getting a cursor?

2006-09-28 Thread Dieter Maurer
Paul Winkler wrote at 2006-9-27 17:44 -0400: I have the impression that there is no standard way to get access to a cursor from a Zope DA. Is that true? True. But you can get at a cursor for each DA using DA specific implementation details, as the DA needs a cursor itself. And as most Zope

Re: [Zope-DB] Zope database connectivity

2006-09-29 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-9-28 23:05 +0200: ... I don't know how abort of ZODB resource managers works but doesn't rollback of ZODB resource manager remove _v_ variables? Usually not. An abort only deactivates (and deactivation kills the _v_ variables together with other content) those

Re: [Zope-DB] Zope and MySQL talking on Windows

2006-10-02 Thread Dieter Maurer
shahrzad khorrami wrote at 2006-9-30 12:42 +: ... I Installed The Zope MySQL Database Adapter (ZMySQLDA) and The Python MySQL Database Interface (MySQLdb) to Zope's Products directory (Zope/lib/python/Products) , but it didn't work ! In principle, it should work. Have you followed

Re: [Zope-DB] Pitfall: mxODBCZopeDA and test runner in 2.9+

2006-10-18 Thread Dieter Maurer
M.-A. Lemburg wrote at 2006-10-18 12:02 +0200: ... As I understand it, the only case that the PYC cleaner is trying to work around here is a local configuration problem which only occurs if some PY file was removed upstream. In such a case, checking in the PYC files seems like the proper fix,

Re: [Zope-DB] [ANN] Modified version of DCOracle2 is available

2006-11-22 Thread Dieter Maurer
Maciej Wisniowski wrote at 2006-11-22 15:12 +0100: ... I'm especially interested in licensing. SQLAlchemy is on MIT license, so I think if it will be possible to use SQLAlchemy pool implementation then then this DCOracle2 version may be ZPL. Am I right? I fear that there is a rule that

Re: [Zope-DB] dtml-let variables in sql queries

2006-11-23 Thread Dieter Maurer
Andreas Tille wrote at 2006-11-23 16:06 +0100: Unfortunately dtml-let namepart=namepart + '%' does not seem to work transparently in the SQL-Method Right. ZSQL Methods take their parameters either from explicitly passed keyword arguments or from the request but not from the DTML

Re: [Zope-DB] Sybase Adapter error :: alternatives?

2006-12-31 Thread Dieter Maurer
Pablo Avalos wrote at 2006-12-27 11:28 -0300: Sadly I'm stuck here at work with some Sybase DB, and I need to get some info to the intranet plone-site.. I have recently seen a new announcement of a Sybase module on Search the archive. -- Dieter

Re: [Zope-DB] sql query works in database connector but not in ZSQL method

2007-01-17 Thread Dieter Maurer
robert rottermann wrote at 2007-1-17 15:42 +0100: ... when I execute this directly in the test window of the database connection, it works fine. when i execute the same line in the test window of a ZSQL Method then I get an error: Error, Products.mxODBCZopeDA.ZopeDA.ReplayTransaction:

Re: [Zope-DB] Can I change the ZSQL max_rows default value?

2007-02-08 Thread Dieter Maurer
Robert-Reinder Nederhoed wrote at 2007-2-6 10:29 +0100: Good day, We use Zope 2.8, still from ZMI. We ran into the 1000 limit several times. Instead of remembering to set it to a higher value, I would like to change the ZSQL max_rows default to 5000. Is it possible to do this? It is also

Re: [Zope-DB] mayday: zope does not start with ERROR ZODB.Connection Couldn't load state for 0x01 error

2007-02-08 Thread Dieter Maurer
robert rottermann wrote at 2007-2-6 18:55 +0100: sorry for crossposting. after stoping and restarting zope one of the zeo/zope instances does not start anymore, and stop with an error. what could be the reason. how can we fix it. does not report any error. The object with oid 0x1 is

Re: [Zope-DB] Please help me

2007-02-14 Thread Dieter Maurer
Nguyen Viet Minh Quang wrote at 2007-2-14 04:52 +0700: ... I would like to develop a new product running on Plone that can get data from relational databases (SQL Server and Oracle). I know also to connect to relational databases to install driver adapter. Yes, I found some driver adapter as

Re: [Zope-DB] Please help me about driver adapter

2007-02-16 Thread Dieter Maurer
Nguyen Viet Minh Quang wrote at 2007-2-16 12:42 +0700: ... I would like to use pymssql and another one, although I try to install it more times but it's not working. Can you help me to install it? No. I do not have an MS SQL server (I do not like MicroSoft and do not want to pay them any money).

Re: [Zope-DB] ZMySQLDA on solaris10

2007-02-22 Thread Dieter Maurer
Comunian Alessandro wrote at 2007-2-22 12:30 +0100: ... import _mysql ImportError: python: fatal: relocation error: file /home/wwhypda/plone/instance_test01/lib/python/ symbol mysql_errno: referenced symbol not found You MySQL-python does not fit with your MySQL version:

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

2007-03-26 Thread Dieter Maurer
Andreas Jung wrote at 2007-3-25 17:49 +0200: In the Zope 2 worlds we have dedicated database adapters for different databases. Fortunately the Python world made us a wonderful present called SQLAlchemy that abstracts the different databases. In the Zope world we have some wrappers like

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

2007-03-27 Thread Dieter Maurer
Andreas Jung wrote at 2007-3-27 03:02 +0200: ... Well you know that Zope does not skip with any DA (except the one for Gadyfly). So I am not in the position to replace anything in the Zope core that does not exist :-) You might have attacked Shared.DC.ZRDB which is the base of Z SQL Methods and

Re: [Zope-DB] ZMySQLDA thinks that MySQL has gone away

2007-03-27 Thread Dieter Maurer
Pedro León López wrote at 2007-3-26 23:56 +0200: ... - Module Products.ZMySQLDA.db, line 389, in _abort error: release unlocked lock Other people with the problem: It will be possible fix this?

Re: [Zope-DB] Unicode charset problems dealing with the ZmySQLDA product

2007-04-30 Thread Dieter Maurer
Miguel Sánchez Beato wrote at 2007-4-30 12:33 +0200: I'm having problems when I retrieve data from the database because the data is not rendered using the unicode charset when the zope instance is in a vserver (with a Gentoo Linux distribution), so I get weird characters like 'á' instead of

Re: [Zope-DB] Connecting FileMaker with Zope

2007-05-04 Thread Dieter Maurer
David Daniel Estévez Durey wrote at 2007-5-3 10:44 +0100: I am trying to connect my FileMaker database with Zope, so I need a Zope Database Adapter for FileMaker. I haven't founded any in the Zope site, in exception of mxODBC Zope DA, but this bridge isn't free. I would be so pleased if anyone

Re: [Zope-DB] Unable to fix a POSKeyError

2007-05-20 Thread Dieter Maurer
Ben Lobo wrote at 2007-5-18 17:33 +0100: ... I'm getting a POSKeyError when I try to access a particular file in a Plone site within the ZMI (see error report at You replace this file by a new object using an interative Python interpreter:

Re: [Zope-DB] FileMaker with Zope

2007-05-22 Thread Dieter Maurer
David Daniel Estévez Durey wrote at 2007-5-22 13:54 +0100: ... I'm trying to connect FileMaker with Zope through ODBC, but I'm not sure if I could do this for free, without buying any driver or software. Can anyone explain to me how to do it or if it isn't possible? To access any database via

Re: [Zope-DB] FileMaker with Zope

2007-05-23 Thread Dieter Maurer
David Daniel Estévez Durey wrote at 2007-5-23 10:52 +0100: ... There used to be a ZODBCDA database adapter as Zope product. However, maintenance by stopped and some interested people took it over. Maybe, you try to search for it. Or you pay the XXX Euro and buy the eGenix mxZODBDA,

RE: [Zope-DB] Using dtml-vars in ZSQL methods?

2007-06-17 Thread Dieter Maurer
Ken Winter wrote at 2007-6-16 16:03 -0400: ... Exception Type KeyError Exception Value 'id_list' Traceback (innermost last): ... * Module Products.CMFCore.FSPythonScript, line 164, in _exec * Module None, line 4, in people_delete_control FSControllerPythonScript at

Re: [Zope-DB] Migration from Windows to Linux. How to do it?

2007-07-06 Thread Dieter Maurer
Mongolkhuu Baatar wrote at 2007-7-5 18:26 -0700: I am newbie and sorry for if I ask too simple question. I have designed my Plone site on my localhost (Windows server) machine. Then I need to move my real Zope and Plone server running on the Linux machine. How do I to do this? My both

Re: [Zope-DB] use of cx_oracle adapter from within python script ?

2007-11-16 Thread Dieter Maurer
banaouas wrote at 2007-11-16 07:15 -0800: I know there is many restrictions when writing python scripts. Only Script (Python) and derived classes are restricted. Python in normal Python modules/packages or External Methods are not restricted. But is it possible to access to oracle (import

Re: [Zope-DB] zope2 rdb and reconnect

2007-12-10 Thread Dieter Maurer
[EMAIL PROTECTED] wrote at 2007-12-9 13:42 -0500: Found the problem. I back ported this connector from a zope3 app. For the retry, being raised was rdb.interfaces.Retry, I changed it to raise ZPublisher.Retry, which works for zope2. Maybe there is a better way for zope2, but this works. A

Re: [Zope-DB] Zope - Oracle Database Connection

2008-12-01 Thread Dieter Maurer
Nachiyappan wrote at 2008-12-1 10:12 +0530: ... i have installed DCOracleda for oracle . but i didn't make connection in zope to oracle ! Zope won't display the connection adapter . Something went wrong with your installation. First of all DCOracleDA needs DCOracle to be installed. DCOracle