Trouble with Connection Reset

[passs]

Hello everybody!

I've met such trouble and have no any idea how to solve it. Look, I have an app (C# + MS SQL Server). Then I test one page with Retional Robot, it makes only one thing, select new item in drop down list, and each this motion brings SQL request to DB. After some time, the page just buzzing and the reason in SQL. Sql Select request works well, but Sql reset doesn't work at one moment. What is the problem I do not know, maybe someone has already met such problem or maybe just has some ideas? I'll be very very thankfull!

Best regards,
Alex

 

[jzelhart]

Can you post the code for the SQL Reset? Maybe that will point us in the right direction.

Hope everyone is having a great day!

Thanks - Jennifer

 

[passs]

SQL Reset it is some inner MS SQL Server function, I don't know which method runs it, maybe sqlConnection.Close(). I found the problem in this Reset function in tracing DB. That is iregular error, and when I stop Robot and press refresh button application continue its work.
That is kinda difficult to determine this problem

 

[jzelhart]

I don't know you may want to check with the SQL Server Forums. I don't have any experience with Robot. Sorry that I couldn't help.

Hope everyone is having a great day!

Thanks - Jennifer

 

[passs]

thanks anyway