RE: FW: Lock_Timeout

Are you using SET LOCK MODE TO WAIT in your programs?  Consider using SET
TRANSACTION ISOLATION LEVEL READ UNCOMMITTED or NOLOCK if concurrency is not
an issue.
 
If the timeouts are occuring when the program is first connecting to the db,
consider increasing the default login time by adding/adjusting the
dbi.database.xxx.msv.logintime setting in the profile (ODBC interface).  We
use 30.  Default is only 5, which is sometimes not enough if the system is
very busy.
 
Tim

  _____  

From: Martha Rangel [mailto:[email protected]] 
Sent: 22 March 2005 14:01
To: [email protected]
Subject: [fourjs-users] FW: Lock_Timeout



 

Hi All,

 

Does anybody know why our 4GL Programs are receiving the error
[Microsoft][ODBC SQL Server Driver][SQL Server]Lock request time out

Period exceeded when running against a SQL Server Database?.

 

IF the lock_timeout is set to -1 which means to wait indefinitely, why our
4GL Programs are failing?. 

 

I noticed in the SQL Server Database Interface this statement :

                                    dbi.database.stores.ifxemul.setlockmode
= false

 

Does this have something to do with the locking issue ?

 

Any ideas would be much appreciated.

 

Thanks,

 


  _____  

 


Martha Rangel

Software Developer

 



 

Phone: (613) 226-5511 ext. 2215
Fax: (613) 226-3377
Email: [email protected]
1 Antares Drive, Suite 400
Ottawa, Ontario, Canada
K2E 8C4

 

This message and any attachments are confidential to the ordinary user of
the e-mail address to which it was addressed and may also be privileged. If
you are not the addressee you may not copy, forward, disclose or use any
part of the message or its attachments and if you have received this message
in error, please notify the sender immediately by return e-mail and delete
it from your system. The sender does not accept liability for any errors or
omissions in the context of this message that arise as a result of Internet
transmission. Any opinions contained in this message are those of the author
and are not given or endorsed by the Harris company or office through which
this message is sent unless otherwise clearly indicated in this message and
the authority of the author to so bind the Harris entity referred to is duly
verified. 

 



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************