SQL Record Retrieval Error, SMuX Provider: Physical connection is not usable

[Stu]

Hey Folks,

Just wondering if anyone has seen anything like this! (the picture shows)

Basically I've been running my couple of nettalk webservers as exes in the day to try and track down a couple of errors that seem to occur under heavy usage.

So yesterday I get a phonecall, "the system is broken! nothing saves!" .. Flick over to the RDC and see this (attached).

--

Record Retrieval Error

Error: (SMuX Provider: Physical connection is not usable.
Unable to open a logical session (08S02)) attempting to access a record from
the dbo.<filename> file. Returning to previous window.

--

Then there's also a sql connection message window.

Have googled a bit, but having trouble understanding just what happened.

Just wondering if anyone has come across this in their travels?

[attachment deleted by admin]

[osquiabro]

is a virtual server VM??

[Bruce]

check out the SQL threads in the Share Knowledge forum for tips on MARS, busy Handling and so on.

[Stu]

Bruce! You're supposed to be away. Go home!

Ahem.

Thanks, yeah. Have gone over the MARS stuff a few times, and that seems to be working fine. This was such a wierd one-off thing (never seen it before), for a file that is used so regularly (like thousands of times a day) that it made me wonder if it wasn't something bigger than just the file.

Anyway. Will investigate some more.