Getting error MS SQL2000

Hi ,

In one of our vendor's prog [VB], we always got this error when it try to assign seq number.

The whole process will run around 5 hrs and the last 5 minutes is the seq number assigning part.

[Microsoft][ODBC SQL Server Driver]Timeout expired

But using the same program etc..., when we re run the seq no assiigning only, it is fine.

Can some body help me to clear this.

thanks

rgs
ananth [Microsoft][ODBC SQL Server Driver]Timeout expiredHI ,

what did you set you connection time to , e.g. for the program to connect to the sql server?did you try setting it higher e.g. from 30 seconds to 60 seconds?