hi,

i use ZODBCDA for connecting to a sybase 1.12 database.

i use it in this way :

## Script (Python) "RH_AppelSQL_script"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=laChaineSQL
##title=
##

REQUEST = context.REQUEST

# Fonction appelant la base de données :

lstResult = context.base_RH.manage_test(laChaineSQL)
return lstResult

and i call this script when i want to execute a SQL request or a stored procedure.

Nevertheless, sometimes i have a error due to a connection failure.
The more suprising is if i use the manage console for testing the connection , that's good .

zope version         : 2.1.2
python version         : 2.1


the error generating by my application is :




  (Object: shortcuts_box)
  File f:\Zope\IntranetLFC\Zope\lib\python\DocumentTemplate\DT_Let.py, line 142, in render
    (Object: isGestionRH="RH_Securite_Is_Gestion_RH_script()"
                        mois="ZopeTime().month()")
  File f:\Zope\IntranetLFC\Zope\lib\python\DocumentTemplate\DT_Util.py, line 205, in eval
    (Object: RH_Securite_Is_Gestion_RH_script())
    (Info: RH_Securite_Is_Gestion_RH_script)
  File <string>, line 2, in f
  File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 322, in __call__
    (Object: RH_Securite_Is_Gestion_RH_script)
  File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 342, in _bindAndExec
    (Object: RH_Securite_Is_Gestion_RH_script)
  File f:\Zope\IntranetLFC\Zope\lib\python\Products\CMFCore\FSPythonScript.py, line 153, in _exec
    (Object: RH_Securite_Is_Gestion_RH_script)
    (Info: ({'script': <FSPythonScript instance at 04AFF5E0>, 'context': <PortalFolder instance at 04897EC0>, 'container': <CMFSite instance at 05963220>, 'traverse_subpath': []}, (), {}, None))
  File Script (Python), line 7, in RH_Securite_Is_Gestion_RH_script
  File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 322, in __call__
    (Object: RH_AppelSQL_script)
  File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 342, in _bindAndExec
    (Object: RH_AppelSQL_script)
  File f:\Zope\IntranetLFC\Zope\lib\python\Products\CMFCore\FSPythonScript.py, line 153, in _exec
    (Object: RH_AppelSQL_script)
    (Info: ({'script': <FSPythonScript instance at 04965B70>, 'context': <PortalFolder instance at 04897EC0>, 'container': <CMFSite instance at 05963220>, 'traverse_subpath': []}, ("select NOMBRE=count(LOGIN) from SECURITE  where LOGIN='fbarsukow' and ID_SERVICE=-2",), {}, None))
  File Script (Python), line 2, in RH_AppelSQL_script
  File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line 176, in manage_test
    (Object: base_RH)
  File c:\projets\projet~2\Divers\install_NT\Zope\lib\python\Products\ZODBCDA\db.py, line 176, in query
sql.error: ('S1000', 50, '[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_cmd_alloc(): user api layer: external error: The connection has been marked dead.')

or " connection link error"


so do you have any solution for a good catching of error and a mean for reconnect the database is the problem occurs?

regards,

fabien Barsukow