Icon View Incident Report

Serious Serious
Reported By: Scott Woods
Reported On: 4/18/2017
For: Version 2.25 Build 3
# 4504 Modifying the TEDBSession RecordLockProtocol Property Causes #506 Session Lock Error

I have downloaded 2.25 and I am now seeing a 506 error.

The error comes when I am loading my database on a thread and connecting to a data source on the thread.  This problem did not occur in 2.24, but I am now seeing it in 2.25 with no code changes to my project.

It appears the 506 error occurs when setting the RecordLockProtocol.

procedure TdmData.LoadData;
 DBName : string;
 DBName := 'YourDBName';
 DBMain.DatabaseName := DBName;
 DBMain.Database := DBName;
 dsMain.RecordLockProtocol := lpOptimistic; // This causes the error
 dsMain.Connected := True;
 dbMain.Connected := True;

Comments Comments and Workarounds
The error would also occur when modifying the TEDBSession RecordChangeDetection, RecordLockRetryCount, and RecordLockWaitTime properties.

The workaround was to connect the session *first*, and *then* modify these session properties.

Resolution Resolution
Fixed Problem on 4/18/2017 in version 2.25 build 4

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial