im the admin of a small lan, ready to pull my hair out. New software package that uses sql server 2000 w/sp3a (standard server 2003) the writer of the software says its a dns error or something else, i checked dns and it looks ok. the error is..

ADO/RDS Error

Description = The connection cannot be used to perform this operation. It

is either closed or invalid in this context. SQLRequest = SELECT GuID,

Title, sqltext, exeversion, lastupdated, orderby, appliedflag, FROM

sqlupdate WITH (NO LOCK) WHERE appliedflag =0 ORDER BY Orderb

----------------

You might try using SQL Profiler to capture attentions to see if there is
anything that will give you a clue as to what is happening. It does appear
that the connection is possibly getting dropped.

Rand
This posting is provided "as is" with no warranties and confers no rights.