.NET connection - Query time-out

• baydata

  Grasshopper

  Points: 16

  More actions

  April 29, 2005 at 3:01 am

  #88897

  I am converting my apps from VS6 to .NET.

  In ADO I could add a query timeout value for  the connection to SQL Server.

  In ADO.NET I cannot use the same connection string.

  How do I increase the time for a query to run in ADO.NET as

  some of my procedures are lengthy?

  Mike

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  April 29, 2005 at 4:49 am

  #555835

  Just use the timeout properties on Connection and Command.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/