General Network Error & SQL Cursors?

[Raterus]

Has anyone experienced a "General Network Error" while executing a Stored Procedure that uses T-SQL Cursors?

Of course this error has to occur at random times, so I don't know exactly what is causing it, but it is always with one specific stored procedure, and this stored procedure is the only one that uses cursors. I ONLY get this error when using ADO.net & ExecuteNonQuery, when I run the query from query analyzer I don't get the error. I've also ran this code on other computers, and haven't gotten the error yet. But if there was something wrong with the network wiring of my computer, why is it only THIS procedure I'm having problems with? Very weird..

Any ideas?
--Michael

 

[Val Mazur]

Hi,

Are you using SSL encryption or not?

--
Val Mazur
Microsoft MVP


Has anyone experienced a "General Network Error" while executing a Stored
Procedure that uses T-SQL Cursors?

Of course this error has to occur at random times, so I don't know exactly
what is causing it, but it is always with one specific stored procedure, and
this stored procedure is the only one that uses cursors. I ONLY get this
error when using ADO.net & ExecuteNonQuery, when I run the query from query
analyzer I don't get the error. I've also ran this code on other computers,
and haven't gotten the error yet. But if there was something wrong with the
network wiring of my computer, why is it only THIS procedure I'm having
problems with? Very weird..

Any ideas?
--Michael

 

[Raterus]

No, I'm not. This is all within a LAN.