ConnectionTransact error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ConnectionTransact error

I have an application that’s just started coming up with this error, apparently randomly – ConnectionTransact (TransactNamedPipe()).
Connection broken.
State:01000,Native:6,Origin:[Microsoft][ODBC SQL Server Driver][Named Pipes]
State:08S01,Native:4,Origin:[Microsoft][ODBC SQL Server Driver][Named Pipes] The odd thing is that I’m not using named pipes – I’m using tcp/ip. The only reference I can find elsewhere to this error suggests it’s a licencing problem, but I’m running sql server 2000 with a 1-processor licence so this shouldn’t be a problem. Anybody got any ideas? Thanks
Keith Worden
Error is from one Work Station or all Work Station?
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
The program is a server application and only ever runs on one machine. I can’t make it happen on demand – there has to be a certain amount of activity.
]]>