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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by alk

  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