[Zope] ZSybaseDA not working

[Manuel Amador (Rudd-O)]

Hi to everyone, especially the experts =)

The reason for this email is an urgent need for a Sybase ASE database to
work properly.  Here's the deal.  It worked like a charm on windows with
ODBC.    But now I moved to Linux, compiled ZSybaseDA and installed it. 
It works for selects and updates, etcetera, both in the test tab and in
ZSQL methods.

BUT when I try to call a stored procedure, well, lemme paste the
traceback.  A traceback is worth a million explanations:

--------- traceback ----------------------------------------
Zope Error

                         Zope has encountered an error while publishing
this resource. 

                         Error Type: Error
                         Error Value: Error processing exec
sp_gn_regionales
                         '0990006792001' , null , NULL Stored procedure
'sp_gn_regionales'
                         not found. Specify owner.objectname or use
sp_help to check whether
                         the object exists (sp_help may produce lots of
output). 



                         Troubleshooting Suggestions

                             The URL may be incorrect. 
                             The parameters passed to this resource may
be incorrect. 
                             A resource that this resource relies on may
be encountering an error. 

                         For more detailed information about the error,
please refer to the HTML
                         source for this page. 

                         If the error persists please contact the site
maintainer. Thank you for your
                         patience. 





                
                                                                             



                                           Cambiada el: 2000/10/30
16:03:22.4513 GMT-5
                  Website copyright grupo SUPÁN. Diseñado por Manuel
Amador (Rudd-O), OpenCorp
                                                                         
S.A.



Traceback (innermost last):
  File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in
publish_module
  File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 187, in
publish
  File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in
zpublisher_exception_hook
    (Object: Traversable)
  File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 171, in
publish
  File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 160, in
mapply
    (Object: index_html)
  File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 112, in
call_object
    (Object: index_html)
  File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 177, in
__call__
    (Object: index_html)
  File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line
528, in __call__
    (Object: index_html)
  File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 168, in
__call__
    (Object: form)
  File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line
528, in __call__
    (Object: form)
  File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 168, in
__call__
    (Object: dw_gn_regionales)
  File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line
528, in __call__
    (Object: dw_gn_regionales)
  File /usr/local/zope/lib/python/DocumentTemplate/DT_In.py, line 633,
in renderwob
    (Object:
sp_gn_regionales(cod_empresa=REQUEST.cod_empresa,cod_regional=''))
  File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 337,
in eval
    (Object:
sp_gn_regionales(cod_empresa=REQUEST.cod_empresa,cod_regional=''))
    (Info: REQUEST)
  File <string>, line 0, in ?
  File /usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py, line 453, in
__call__
    (Object: sp_gn_regionales)
  File /usr/local/zope/lib/python/Products/SybaseDAv2/db.py, line 299,
in query
  File /usr/local/zope/lib/python/Products/SybaseDAv2/db.py, line 333,
in _error
Error: (see above)
--------- end traceback --------------------------------------

I'm baffled.  I just got too accustomed to Zope so that we committed to
the development of reports on the Web instead of with PowerBuilder.  If
this doesn't work, I will have to sustain several hours of psychological
punishment, and I will have to dump Zope in favor of a better solution. 
These kinds of things make Zope not suitable for enterprise
applications, where you can't rely on poorly documented things like
ZSybaseDA.  I'm even angry at liking Zope now.

For the record, I'm using Sybase ASE 11.9.2 with the latest OpenClient
RPM from Sybase.com.  As you can see, this is a ZSybaseDA problem since
everything but the stored procedures return data or alter/update it.

I need an answer soon.  OR, at least a hint of where could I tap
information sources to DigitalCreations directly for commercial support,
regarding Sybase support for our needs.
I read about the agreement between Sybase and Digital Creations.  But I
can't find any information regarding Zope support in either Digital
Creations' or Sybase's web sites.

And I have exactly one week.

Any suggestions, fixes, patches, OR alternatives are welcome.

Many thanks.

PD: Can I authenticate using GUF against the Sybase database security
system?  If so, how?
-- 
Manuel Amador (Rudd-O)