Latest posts on AUTOCOMMIT в MSSQL topichttp://python.su/forum/topic/856/2007-06-08T16:04:26+03:00Общий :: Базы данных :: AUTOCOMMIT в MSSQL
2007-06-08T16:04:26+03:00dvs5700пример из <a href="http://svn.sqlobject.org/SQLObject/branches/victorng/sqlobject/mssql/mssqlconnection.py">http://svn.sqlobject.org/SQLObject/branches/victorng/sqlobject/mssql/mssqlconnection.py</a><br/><div class="code"><pre> <span class="k">def</span> <span class="nf">_setAutoCommit</span><span class="p">(</span><span class="bp">self</span><span class="p">,</span> <span class="n">conn</span><span class="p">,</span> <span class="n">auto</span><span class="p">):</span>
<span class="c">#raise Exception(repr(auto))</span>
<span class="k">return</span>
<span class="c">#conn.auto_commit = auto</span>
<span class="n">option</span> <span class="o">=</span> <span class="s">"ON"</span>
<span class="k">if</span> <span class="n">auto</span> <span class="o">==</span> <span class="mi">0</span><span class="p">:</span>
<span class="n">option</span> <span class="o">=</span> <span class="s">"OFF"</span>
<span class="n">c</span> <span class="o">=</span> <span class="n">conn</span><span class="o">.</span><span class="n">cursor</span><span class="p">()</span>
<span class="n">c</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s">"SET AUTOCOMMIT "</span><span class="o">+</span><span class="n">option</span><span class="p">)</span>
<span class="n">conn</span><span class="o">.</span><span class="n">setconnectoption</span><span class="p">(</span><span class="n">SQL</span><span class="o">.</span><span class="n">AUTOCOMMIT</span><span class="p">,</span> <span class="n">option</span><span class="p">)</span>
</pre></div>
Общий :: Базы данных :: AUTOCOMMIT в MSSQL
2007-06-07T17:42:24+03:00alexber2205688<blockquote><em>dvs</em><br/>Если для доступа к БД используется драйвер mxODBC, то так:<br/><div class="code"><pre> db_conn.setconnectoption(mx.ODBC.Windows.SQL.AUTOCOMMIT, mx.ODBC.Windows.SQL.AUTOCOMMIT_OFF)</pre></div></blockquote>используется pymssql
Общий :: Базы данных :: AUTOCOMMIT в MSSQL
2007-06-06T18:17:21+03:00dvs5662Если для доступа к БД используется драйвер mxODBC, то так:<br/><div class="code"><pre> db_conn.setconnectoption(mx.ODBC.Windows.SQL.AUTOCOMMIT, mx.ODBC.Windows.SQL.AUTOCOMMIT_OFF)</pre></div>
Общий :: Базы данных :: AUTOCOMMIT в MSSQL
2007-06-04T18:57:02+03:00alexber2205627Кто знает как сделать AUTOCOMMIT в MSSQL ?