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