Hello to everyone, I have a problem and I hope you can help me. I am programming in Visual Studio 2005, C# and ASP.NET, programming a Web Site where I connect myself to a Database made in SQL-Server 2000.
I use a DataSet created as an XML schema with DataSet classes (. xsd) that it comes in the installed Templates that the Visual Studio brings in Add new Item. This file establishes all the connections by it self and I only have to grab the Stored Procedures that I will use into the design's view of the file and it is ready. This file uses the Connection strings that are defined in the Web.Config to establish the connection. But the problem is that to the 30 seconds the connection gives error of timeout and some of the procedures that I use delay more than that. The guilt doesn't seem to be of the SQL-Server because in a client of SQL the procedures comes out well and it takes a long time what has to take a long time without falling the connection, 1 minute or 2 or what is. I have also tried putting in the connection string of the Web.Config the timeout in 200 seconds (;Connect Timeout=200) or something like that but it still continues falling to the 30 seconds. I suppose that the guilt has it the DataSet, but I don't know how to change the timeout of it because it doesn't almost have properties and in the code view it is not seen anything that it says the time of life of the connection neither anything. Sorry sorry for mi English. I wait that you can help me, thanks to all of you
