Clarion hsmt error

Tags: #<Tag:0x00007fc0dd50cc88> #<Tag:0x00007fc0dd50c8f0>

i receive this error in one of the ms sql table:
image

when i check the data in that table, it shows the following data:

i have already put the following in that table properties (driver option) in the dct:

/BUSYHANDLING=2 /MULTIPLEACTIVERESULTSETS=TRUE /ISOLATIONLEVEL=2 /MARS_Connection=Yes /Trusted_Connection=True

if i delete the table and create new data again, it works but after few records, the error comes again.

kindly advice how to handle this problem. thanks.

jason
c11
fm3 5.5

Hi

Be aware that you have to enter your driver properties in the FM3 global template to work.

Regards Niels

hi niels
thanks for the reply. yes, i did put this value:
/BUSYHANDLING=2 /MULTIPLEACTIVERESULTSETS=TRUE /ISOLATIONLEVEL=2 /MARS_Connection=Yes /Trusted_Connection=True

image

(btw, niels, i have sent a message to you via nettalk central for api question. hope it reached you.)

Normal fix for this is to add /BUSYHANDLING=2 but without MARS
Do you really need multiple active results sets?
Try connection without the 2 MARS entries and see if the HMST errors go away

thanks graham. Will remove the entries and try again.