SQL Connection String

sql
Tags: #<Tag:0x00007f46daec1e18>

#1

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)

#2

It’s ok to add “/BUSYHANDLING = 2” twice? Maybe this could be causing the issue?


#3

The error:

Comes from trying to open an MDI window from a non MDI window. Not sure if that’s contributing.


#4

You said that you connect using username/pass… Trustedconnection means “Windows Authentication”…
As far as I have read…

HTH
Theodore