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 |