Sql Server, pessimist locking and transactions

Hi everyone!

 

I am having a problem in one customer who is running 4GL against a SQL
Server database.  The error is raised upon the commit work, the commit work
causes an error - 6372, with sqlca.sqlerrd[2] = 0!.  

 

On Informix systems, the program runs without errors.  I reviewed the code
and everything is correct.  

 

For what I have read, it seems is a missing alignment between @TRANCOUNT and
the expected trancount from the ODBC driver.  

 

Any ideas would be appreciated.  

 

 


  _____  


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.