Re: [Zope] Problem with cursor

27 May 2003

      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

Antonio Carlos Bortoletto wrote:
...
Troy,
thank very much for your atencion. ..
it was this that you wanted?
Traceback (innermost last):
a.. Module ZPublisher.Publish, line 98, in publish
  b.. Module ZPublisher.mapply, line 88, in mapply
  c.. Module ZPublisher.Publish, line 39, in call_object
  d.. Module OFS.DTMLDocument, line 131, in __call__
  e.. Module DocumentTemplate.DT_String, line 474, in __call__
  f.. Module OFS.DTMLDocument, line 124, in __call__
  g.. Module DocumentTemplate.DT_String, line 474, in __call__
  h.. Module OFS.DTMLDocument, line 124, in __call__
  i.. Module DocumentTemplate.DT_String, line 474, in __call__
  j.. Module DocumentTemplate.DT_In, line 628, in renderwob
  k.. Module DocumentTemplate.DT_Util, line 201, in eval
  __traceback_info__: querys_ger
  l.. Module <string>, line 2, in f
  m.. Module Shared.DC.ZRDB.DA, line 428, in __call__
  n.. Module Products.ZODBCDA.db, line 198, in query
sql.error: ('24000', 0, '[Microsoft][ODBC SQL Server Driver]Invalid cursor
state')
Antonio
----- Original Message -----
From: "Troy Farrell" <troy@entheossoft.com>
To: "Antonio Carlos Bortoletto" <antonio.bortoletto@websolucoes.com.br>
Cc: <zope@zope.org>
Sent: Tuesday, May 27, 2003 4:10 PM
Subject: Re: [Zope] Problem with cursor
...
Hello Antonio.
Please don't send HTMLMail to the mailling list.  Some people have a
hard time reading your email.
Does your ZSQL method work when you test it?  Also, can you send us the
traceback?  This is usually found in the /error_log or by viewing the
html source on your error page.
Troy
Antonio Carlos Bortoletto wrote:
...
Hello. .
My name is Antonio.. .  I'm brazilian . . I don't speak english very
well. .(we speak portuguese in Brazil)..
I have a problem. .   I thank who very I will be able to help me.. ..
<html>
   <head></head>
   <body>
       <dtml-in expr="my_query">
           (..)
       </dtml-in>
<dtml-in expr="my_query">
           (..)
       </dtml-in>
   </body>
</html>
This is the error:
Error Type: sql.error
Error Value: ('24000', 0, '[Microsoft][ODBC SQL Server Driver]Invalid
cursor
...
...
state')
How I make to decide this problem? I need to position the cursor on
begin of file. . . this is certain?
Again..... .I thank who very I will be able to help me
Thank you very much ..
Antonio

Troy Farrell

tags

participants (1)