Check value of QueryTimeOut using SQLGETPROP( ). You can set it max to 600 sec or 0 to disable timeout.

>Hi,
>
>I have a table with more than 600,000 rows of data. I want to transfer the data from the field Group_ to INS_GROUP1 within the same table, in such a way that at the end both the fields have exactly the same data. I wrote the following update query.
>
>Update XXX Set INS_GROUP1 = Group_ where INS_GROUP1 is null
>
>After executing for two minutes, I got the following error..
>
>[Microsoft][ODBC SQL SERVER driver]TimeOut expired.
>
>On pressing OK, it stops exectuting the query further. I have the Driver number 3.70.09.61. Any help is highly appreciated.
>