Hi all,

Im using sqlserver 2000 and code language used c#,asp.net.
im making some reports and doing there transaction using stored procedures.
My problem is allways system is running correctly in our(my PC) side. But it made error timeout expired at clientside machine.
There are so many forums given answers to solve this "Connection strig time out period increasing."
But i want to know how i do it in client side.I think i dont need to increase connection string timeout period. Are there any other way to do(? have anyway to do it clients sqlserver) in sqlserver. If its YES please help me to do it.
thanks all

__________________
MSB

Well if the connection is being made but the actual query is taking too long then adjust the CommandTimeout on the Command instance.

--

Joe (Microsoft MVP - XML)

or write more efficient code that executes quicker before the timeout occurs.

If you are using parameter(s) in your stored procedure, try this examples :
    ... sp_example (@varTest as varchar(30))
    declare @Test as varchar(30)
    set @Test = @varTest
    ...
then use @Test in your select command instead of @varTest.

Hope this will help.