<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>[DUG] Rhino Mocks</TITLE>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18999"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>I'm having a strange error recently. We have
a program that has been running on a Win2003 server for a long time, and
suddenly from last week it comes up 'Object was open'
errors.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>Typically, the program uses 2 TADOQuery, one will
select/Edit/Post, another one with an 'Insert into xxx' query, both pointing to
a same SQL Server 2005 table. The pattern appears on many
places.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>Disregard the nicety of the logic, it has been done
that way for over 5 years, first on Win 2000 server with SQL Server 2000, and
later on Win 2003 server with SQL Server 2005, and was all fine, until about a
week ago.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>I have tried Google, but couldn't really find any
useful link to my situation, although there are lots of link to the same
error.</SPAN></FONT><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011> I'm suspecting some kind of OS patch or
such which changed behaviour of ADO or MDAC or SQL Server.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>Anyone has a suggestion to my situation? I'm not
keen on changing all the code to use different logic, as it would require
fair amount of coding and testing.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>Thanks,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=248354407-21022011>Edward</SPAN></FONT></DIV></BODY></HTML>