<br><font size=2 face="Courier New">hi, <br>
<br>
i use ZODBCDA for connecting to a sybase 1.12 database.</font>
<br>
<br><font size=2 face="Courier New">i use it in this way :</font>
<br>
<br><font size=2><tt><i>## Script (Python) "RH_AppelSQL_script"</i></tt></font>
<br><font size=2><tt><i>##bind container=container</i></tt></font>
<br><font size=2><tt><i>##bind context=context</i></tt></font>
<br><font size=2><tt><i>##bind namespace=</i></tt></font>
<br><font size=2><tt><i>##bind script=script</i></tt></font>
<br><font size=2><tt><i>##bind subpath=traverse_subpath</i></tt></font>
<br><font size=2><tt><i>##parameters=laChaineSQL</i></tt></font>
<br><font size=2><tt><i>##title=</i></tt></font>
<br><font size=2><tt><i>##</i></tt></font>
<br>
<br><font size=2><tt><i>REQUEST = context.REQUEST</i></tt></font>
<br>
<br><font size=2><tt><i># Fonction appelant la base de données :</i></tt></font>
<br>
<br><font size=2><tt><i>lstResult = context.base_RH.manage_test(laChaineSQL)</i></tt></font>
<br><font size=2><tt><i>return lstResult</i></tt></font>
<br>
<br><font size=2 face="Courier New">and i call this script when i want to execute a SQL request or a stored procedure.</font>
<br>
<br><font size=2 face="Courier New">Nevertheless, sometimes i have a error due to a connection failure.</font>
<br><font size=2 face="Courier New">The more suprising is if i use the manage console for testing the connection , that's good .</font>
<br>
<br><font size=2 face="Courier New">zope version : 2.1.2 <br>
python version : 2.1 </font>
<br>
<br>
<br><font size=2 face="Courier New">the error generating by my application is :</font>
<br>
<br>
<br><font size=2 face="Courier New"><br>
<br>
(Object: shortcuts_box)</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\DocumentTemplate\DT_Let.py, line 142, in render</font>
<br><font size=2 face="Courier New"> (Object: isGestionRH=&quot;RH_Securite_Is_Gestion_RH_script()&quot;</font>
<br><font size=2 face="Courier New"> mois=&quot;ZopeTime().month()&quot;)</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\DocumentTemplate\DT_Util.py, line 205, in eval</font>
<br><font size=2 face="Courier New"> (Object: RH_Securite_Is_Gestion_RH_script())</font>
<br><font size=2 face="Courier New"> (Info: RH_Securite_Is_Gestion_RH_script)</font>
<br><font size=2 face="Courier New"> File &lt;string&gt;, line 2, in f</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 322, in __call__</font>
<br><font size=2 face="Courier New"> (Object: RH_Securite_Is_Gestion_RH_script)</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 342, in _bindAndExec</font>
<br><font size=2 face="Courier New"> (Object: RH_Securite_Is_Gestion_RH_script)</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\Products\CMFCore\FSPythonScript.py, line 153, in _exec</font>
<br><font size=2 face="Courier New"> (Object: RH_Securite_Is_Gestion_RH_script)</font>
<br><font size=2 face="Courier New"> (Info: ({'script': &lt;FSPythonScript instance at 04AFF5E0&gt;, 'context': &lt;PortalFolder instance at 04897EC0&gt;, 'container': &lt;CMFSite instance at 05963220&gt;, 'traverse_subpath': []}, (), {}, None))</font>
<br><font size=2 face="Courier New"> File Script (Python), line 7, in RH_Securite_Is_Gestion_RH_script</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 322, in __call__</font>
<br><font size=2 face="Courier New"> (Object: RH_AppelSQL_script)</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\Scripts\Bindings.py, line 342, in _bindAndExec</font>
<br><font size=2 face="Courier New"> (Object: RH_AppelSQL_script)</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\Products\CMFCore\FSPythonScript.py, line 153, in _exec</font>
<br><font size=2 face="Courier New"> (Object: RH_AppelSQL_script)</font>
<br><font size=2 face="Courier New"> (Info: ({'script': &lt;FSPythonScript instance at 04965B70&gt;, 'context': &lt;PortalFolder instance at 04897EC0&gt;, 'container': &lt;CMFSite instance at 05963220&gt;, 'traverse_subpath': []}, (&quot;select NOMBRE=count(LOGIN) from SECURITE where LOGIN='fbarsukow' and ID_SERVICE=-2&quot;,), {}, None))</font>
<br><font size=2 face="Courier New"> File Script (Python), line 2, in RH_AppelSQL_script</font>
<br><font size=2 face="Courier New"> File f:\Zope\IntranetLFC\Zope\lib\python\Shared\DC\ZRDB\Connection.py, line 176, in manage_test</font>
<br><font size=2 face="Courier New"> (Object: base_RH)</font>
<br><font size=2 face="Courier New"> File c:\projets\projet~2\Divers\install_NT\Zope\lib\python\Products\ZODBCDA\db.py, line 176, in query</font>
<br><font size=2 face="Courier New">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.')<br>
</font>
<br><font size=2 face="Courier New">or " connection link error" </font>
<br>
<br>
<br><font size=2 face="Courier New">so do you have any solution for a good catching of error and a mean for reconnect the database is the problem occurs?</font>
<br><font size=2 face="Courier New"><br>
regards, <br>
<br>
fabien Barsukow</font>