timeout expired in SQL Server (newbie)

[AdamP]

How do you increase the time out property for queries in SQL? I keep getting the error: "Microsoft ODB SQL Server Driver Timeout Expired" on a large update query.

 

[tlbroadbent]

You can set the timeout value in the ODBC driver. See the ODBC documentation for details.

Have you attempted to optimize the query to avaoid the timeout problem. It is better to optimize than increase timeout values or soon you'll have dozens of slow queries bogging down the server and every query wil run slowly.

Check out the optimizations links at...

http://tlbroadbent.home.attbi.com/sql_and_access/sql_performance.htm

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.