[RESOLVED] A transport-level error has occurred when sending the request to the server. (provide

The whole error is (while starting a vb2008 app)

"A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"

I've been trying to figure this out for a couple days, searched through many forums and google searches, etc.. seems like this error has been puzzling people for years.

for me the problem turned out to be the sql server database had errors in it, I ran a

ALTER DATABASE ltc11
SET single_user WITH ROLLBACK IMMEDIATE;
go
DBCC checkdb ('ltc11', repair_allow_data_loss);
go

ALTER DATABASE ltc11
SET MULTI_USER

and that fixed the problem, I guess that error can be used for more than one type of error, just thought I'd pass this along..

(the data wasn't important, just a test database)