[Zope] Problem with cursor

[Antonio Carlos Bortoletto]

Hello Troy.
Thanks very much for your help and atention. . .. It forgives me for the
delay of the reply
I will read on ZODBCDA and eGenix solution....

Thanks.
Antonio

----- Original Message -----
From: "Troy Farrell" <troy@entheossoft.com>
To: "Antonio Carlos Bortoletto" <antonio.bortoletto@websolucoes.com.br>
Cc: "Zope" <Zope@zope.org>
Sent: Tuesday, May 27, 2003 6:08 PM
Subject: Re: [Zope] Problem with cursor


Please keep your replies on the list so others can help and the
discussion is archived.

Knowing that the call works if called just once on a page verifies that
the bug is with ZODBCDA not moving the cursor as it ought (or not
caching the results...)

If you must host on W2k, look at the eGenix solution.

Troy

Antonio Carlos Bortoletto wrote:
> I will read these links.. thanks . .. you are helping me very. .
> . . . but. . .answering its pergunta: yes. . .'my_query' work if it is
> called only once int that page.. .
> This file (with the querys) was running in linux, with ODBC driver of
sybase
> . . . and this error did not exist.. . .
> but, now, itīs running in Windows2000. . with ODBC driver of microsoft. ..
>
> ----- Original Message -----
> From: "Troy Farrell" <troy@entheossoft.com>
> To: "Antonio Carlos Bortoletto" <antonio.bortoletto@websolucoes.com.br>
> Cc: "Zope" <Zope@zope.org>
> Sent: Tuesday, May 27, 2003 4:56 PM
> Subject: Re: [Zope] Problem with cursor
>
>>That is the traceback we need.  Unfortunately, I can't make much sense
>>of it.  Does 'my_query' work if it is called only once in that page?
>>
>>After a little bit of google searching, I've found two things:
>>
>>1) http://mail.zope.org/pipermail/zope/2000-January/101259.html
>>
>>ZODBCDA has been doing this for a long time and no one has posted any
>>(easily located) fixes.
>>
>>2) http://www.zope.org/Products/DA/ZODBCDA
>>
>>ZODBCDA is free, but is old and hasn't been updated/bugfixed.  It is a
>>binary release, but is licensed ZPL - unusual.  I wonder if the creator
>>would release source for this...
>>
>>The other options I see would be to use freeTDS on a *nix system or
>>purchase eGenix.com's mxODBC Zope DA.
>>
>>Troy