After starting to use Clarion 11 I am getting strange errors from some of the users of the program, such as:
Invalid Cursor state(24000)
Unable to open MDI window (No APPLICATION active)
Error: (Connection is busy with results for another command (S1000) attempting
to access a record from the <sql table or view> file. Returning to previous
window.
Normally this error just throws you back to a earlier window but annoyingly often the program crashes.
I have changed the Driveroptions string to allow for a more robust connection to the SQL Server, since these errors seem to happen more where there are many users connected to the SQL Server.
Currently the users are connected to the SQL Server with the same User name and Password since Windows Authentication is problematic.
The Connection (driver) string uses the following options:
LOC:DriverOptions = **'/TRUSTEDCONNECTION = TRUE,/BUSYHANDLING = 2,/IGNORETRUNCATION = TRUE,/BUSYHANDLING=2,/MULTIPLEACTIVERESULTS=TRUE'**
Do you recommend anything else?
S100 event viewer
Faulting application name: mxmenu.exe, version: 14.0.0.0, time stamp: 0x5c1a558e
Faulting module name: ClaRUN.dll, version: 11.0.0.13244, time stamp: 0x5bbb993c
Exception code: 0xc0000005
Fault offset: 0x000f8589
Faulting process ID: 0x1228
Faulting application start time: 0x01d498752b2ef25a
Faulting application path: C:\Grettir\Project\Maintx11\mxmenu.exe
Faulting module path: C:\Grettir\Project\Maintx11\ClaRUN.dll
Report ID: 76a11dd9-dd6b-4a78-9d8b-d724c0aeb1a9
Faulting package full name:
Faulting package-relative application ID:
Faulting application name: mxmenu.exe, version: 14.0.0.0, time stamp: 0x5c1a558e
Faulting module name: ClaRUN.dll, version: 11.0.0.13244, time stamp: 0x5bbb993c
Exception code: 0xc000041d
Fault offset: 0x000f8589
Faulting process ID: 0x1228
Faulting application start time: 0x01d498752b2ef25a
Faulting application path: C:\Grettir\Project\Maintx11\mxmenu.exe
Faulting module path: C:\Grettir\Project\Maintx11\ClaRUN.dll
Report ID: 83e8d109-61f7-401b-8132-a64ed8f1e81a
Faulting package full name:
Faulting package-relative application ID:
Two errors reported!
0xc000041d --> STATUS_FATAL_USER_CALLBACK_EXCEPTION
0xc0000005 --> ACCESS_DENIED (Access Violation)