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
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
participants (2)
-
Antonio Carlos Bortoletto -
Troy Farrell