Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: alk
  • Order by date
  1. alk

    mts inserts, locks table, and never releases table lock!

    There is more to this matter. Apparently,<br>there is some incompatability between the<br>referenced libraries in win 2000 and NT 4.0.<br>(the com+ reference vs. the MTS libraries).<br>When doing transactions, dtc does not<br>send a &quot;commit&quot; message to sql server, and<br>the whole...
  2. alk

    getting sql server messages after disconnecting a recordset

    Apparently, the error handling is not contingent on the<br>connection object. The error object is immediately<br>updated after each raised errors, despite closed connection<br>objects or disconnected recordsets.
  3. alk

    mts inserts, locks table, and never releases table lock!

    Apparently, if the dtc on the server fails, the process<br>is orphaned and all locks are kept indefinitely. Check<br>this URL:<A HREF="http://support.microsoft.com/support/kb/articles/" TARGET="_new">http://support.microsoft.com/support/kb/articles/</A><br>Q195/5/42.ASP.<br><br>
  4. alk

    mts inserts, locks table, and never releases table lock!

    I insert a row, and the component runs to setcomplete,<br>but awaits message from DTC. <br><br>In sql server the log message reads: &quot;Awaiting DTC message, UOW ...guid...State PREPAR&quot;. The same component runs on another machine under windows 2000; but will not run on this machine under...
  5. alk

    getting sql server messages after disconnecting a recordset

    I am trying to get the error messages from<br>sql server before disconnecting a recordset.<br>I am accessing the error collection of the<br>connection object before it gets close and<br>the recordset disconnected. Is this the right<br>approach, and what is the syntax? Thanks much!
  6. alk

    overhead with vb components

    i have a hard time getting low level information<br>on mts. does anybody have a good source book/site?<br><br>sample topics:<br>1) without object pooling, vb components expend<br>considerable resources on component/context/wrapper<br>construction and destruction. resource-usage and<br>timing...

Part and Inventory Search

Back
Top