Connection Timeout problem

Question

Hi I have one problem with com+ implementation we are doing one project which has com+ implementation. while I running the application by deleteing the com+ component in the component service manager it is working perfectly.But If I run the application without deleteing the com+ component in the component service manager it is giving the query timeout error . Moreover the query timeout property is set as 0 as explicitly. Why it is happening so? Can anyone pls help me. It is urgent

karthik.gopalan · Answer

Hi Sorry the actual problem is as below. We have a DataAccessComponent (our own component for database operations) in which CommandTimeOut property for the Sqlcommand object is set as 0 (which means unlimited). This is working fine at the development side. But during implementation at the clients place we are error 'Timeout expired'. All the settings at the clients place are same as at the development site. The unique thing is it is working fine at the client place also if the component is deleted from the Component Services and run for the first time. If the application is run for the second time without deleting the component from the Component services it is giving the above error. We are accessing a webservice to get the data which will be put into the database. We are using SQLserver. And this error is occuring at the implementation site only after including the CommandTimeout=0 for the SqlCommand instance. Before this was implemented it wasworking fine at both sides. Thanks in Advance