SQL Server 2005 Hanging - Selecting uncommitted data

forum.connectivity (1998-2005) & forum.td.connectivity (2005-2010)
Laurence Harvey

SQL Server 2005 Hanging - Selecting uncommitted data

Post by Laurence Harvey » 01 Dec 2006, 02:46

 Posted by:  Laurence Harvey 

We have found an issue with using MSS 2005 with odbc connections, some of
our code inserts data, then reselects the data back with a select using a
different handle. This hasn't caused any issues before but in one customer
this causes a lock up. The timeout error doesn't occur as you would expect
if trying to select data that is uncommitted by another user.

Although obviously we could recode to avoid selecting uncommitted rows, can
anyone tell me why this works sometimes but not others. Some kind of
setting in MSS that we're unaware of maybe. The code works ok on other MSS
2005 & MSS 2000 servers and oracle & sqlbase.

TIA

Laurence Harvey

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests