Progress
DataServer for
Microsoft SQL Server
Guide


The NO–WAIT Option

The NO–WAIT option works for DataServer applications in the same way that it works for Progress applications: the DataServer uses a time-out mechanism. If SQL Server™ does not return a record, the DataServer considers the record to be locked. It then cancels the request to the SQL Server™ and sets the “locked” and “not available” conditions.

During a period of heavy demand, you might encounter situations where the “not available” condition is set although the record is not currently locked by a user. In this case, you might want to increase the time-out interval by using the -Dsrv RESP_TIMEOUT parameter.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095