Connection.Options.DefaultLockTimeout what was the lock value before this new option was introduced?

[toni.brown]

Hi,

I'm migrating a D7 project which is still using sdac 4.35 to XE7 and the later sdac version.

In testing we've noticed we are getting an error like

"Lock request time out period exceeded." which we think is MSSQL related and to do with the 2000ms timeout with the 'new' Connection.Options.DefaultLockTimeout option that we didn't have in the D7 version.

So my question is what was effectively the previous value for waiting on a lock before this option came into play? Was it perhaps indefinite?

Thanks,

Toni

[ViktorV]

The TMSConnection1.Options.DefaultLockTimeout property is used to set the DBPROP_SSCE_DEFAULT_LOCK_TIMEOUT property of the OLE DB provider. If the TMSConnection.Options.DefaultLockTimeout property is set to the default value (2000), the OLE DB provider will use its default values. See more details about this property at: https://technet.microsoft.com/en-us/lib ... .110).aspx This behavior wasn't changed in comparison to SDAC 4.35.

[toni.brown]

Hi Victor,

Thanks for the reply. I'm looking though in the Delphi 7 version and I don't actually see that property in the connection options for I think it was version 4.35.1.15 18-Feb-08

I'm assuming it just waits then indefinitely until there is some command timeout setting in place as well?

For XE7 to mimic the same behaviour, I am currently setting TMSConnection1.Options.DefaultLockTimeout to -1 which seems to do the same thing... does that sound like what -1 should be doing?

Thanks,

Toni

[ViktorV]

Yes, you are right. When setting the TMSConnection.Options.DefaultLockTimeout property to -1, the default value of SQL Server is used, that indicates no time-out period (that is, wait forever).