Clarion 12 - What Problems or Issues have you found?

22

I use a VPS with my internet provider. It has Windows Server 2022 and only SQL Server installed. All ports are closed except those required for SQL Server to work. The connection string contains the IP address or domain name. Everything works perfectly, there are about 50 databases per server with more than 100 users and everything works with 8GB RAM and 200GB SSD.

1 Like
23

Thanks.
I try that many years ago but it was slow - browse with 1000-2000 records loads for 5-10 seconds.
I have 280 tables and 20 views.

24

Re-install fixed it.

25

Hi,

I’m trying to install clarion 12 on my local computer for testing purposes. I’ve installed all needed dependencies but i still have the following error while launching C12 :

Unhandled exception terminated Clarion

Exception Type: System.IO.FileNotFoundException
File Not Found: clarion.asl.dll
Error Message: Impossible de charger le fichier ou l'assembly 'clarion.asl.dll' ou une de ses dépendances. Le module spécifié est introuvable.

Exception thrown: 
System.IO.FileNotFoundException: Impossible de charger le fichier ou l'assembly 'clarion.asl.dll' ou une de ses dépendances. Le module spécifié est introuvable.
Nom de fichier : 'clarion.asl.dll'
   à ICSharpCode.Core.CoreStartup.RunInitialization()
   à ICSharpCode.SharpDevelop.Sda.CallHelper.InitSharpDevelopCore(CallbackHelper callbackHelper, StartupSettings properties)
   à ICSharpCode.SharpDevelop.Sda.SharpDevelopHost..ctor(AppDomain appDomain, StartupSettings startup)
   à ICSharpCode.SharpDevelop.SharpDevelopMain.RunApplication()
   à ICSharpCode.SharpDevelop.SharpDevelopMain.Run(String[] args)
   à ICSharpCode.SharpDevelop.SharpDevelopMain.Main(String[] args)

Can someone help me ? I am currently running on W11 24H2.

26

"all needed dependencies " what is that?

  • as I know there is only vcredist2013_x86.exe needed for clarion
    to work.
27

I have the file “clarion.asl.dll” in C:\Clarion12\bin. Its 154,112 bytes and dated 4/25/2025

There is the below post in DiscussSV Clarion 12 with your same problem and a solution:

-------- Forwarded Message --------
Subject: Re: Please can someone help me with the error when starting C12?
Date: 21 May 2025 01:59:35 -0400
From: Paul Morrison [email protected]
Newsgroups: sv.clarion.clarion12
References: [email protected]

Cristian Olsen (@colsenviking in IG) wrote:

Exception Type: Syste.IO.FileNotFoundException.
Clarion.asl.dll

If this is the same error I had (installing C12 PE on a fresh Windows 11 Virtual Machine for testing) I suspect it’s because the Clarion installer does not trigger the install of the required VC Redistributables. Instead of trying to figure out which ones to install, I first installed the latest C11.1 PE release, which did install the VC files, and after that I was able to install, run, and register C12.

Good luck.
Paul Morrison

28

New problem, Clarion 12 PE,
when clicking on error after generate, nothing hapens, it is not opening the source editor.

29

The SoftVelocity C12 installer appears to be missing a redistributable component. As a result, C12 fails with a “System.IO.FileNotFoundException” error on a clean Windows machine. I have created a quick fix for this issue. Simply download and run it on affected machines.

https://www.setupbuilder.com/downloads/C12_redist.exe

Friedrich

7 Likes
30

Well I still cannot get C12 to run. I’m on Win 10. I’ve run the C12_redist.exe and verified that it did install. I’ve uninstalled and reinstalled C12 a few times with no success. Always the same set of errors:

Clarion Version : 12.0.0.13941
.NET Version         : 4.0.30319.42000
OS Version           : Microsoft Windows NT 6.2.9200.0
Current culture      : English (United States) (en-US)
Working Set Memory   : 53568kb
GC Heap Memory       : 2880kb


Unhandled exception terminated Clarion

Exception Type: System.UnauthorizedAccessException

Exception thrown: 
System.UnauthorizedAccessException: Access to the path 'C:\Users\John\AppData\Roaming\SoftVelocity\Clarion\12.0\ClarionProperties.xml.tmp' is denied.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
   at ICSharpCode.Core.PropertyService.Save()
   at ICSharpCode.SharpDevelop.ClarionLic.IsValid(Boolean askForSerial)
   at ICSharpCode.SharpDevelop.SharpDevelopMain.RunApplication()
   at ICSharpCode.SharpDevelop.SharpDevelopMain.Run(String[] args)
   at ICSharpCode.SharpDevelop.SharpDevelopMain.Main(String[] args)
31

Hi,

Have you tried to run as Admin?
Just my .02

32

Interesting..

I can share another experience. Installed on Windows Server machine using C:\Clarion12 default folder Clarion IDE won’t start unless you give yourself Full Control security permission to the folder.

Just my .02

33

Compiled my set of applications (40 or so) in Clarion 12. All templates updated - just a few problems here and there. All appeared to be working fine. However, using the MSSQL driver with Identity Columns, the Identity Column value is no longer available when inserting child records. For example, the parent table is CONTACTS with an identity column CONTACTKEY. The child table is PHONES, which contains a relational key using CONTACTKEY. However, an error occurs in the relational key when inserting it into PHONES. This only occurs if the parent record is also in “insert mode.” I have checked the SQL table, and the insert record is created with a valid CONTACTKEY value. The Clarion 11 compiled applications all work fine. Any suggestions?

34

Yes, I have and no go.

35

I just tried this too just in case, but, again, no-go.

36

You need to look at AUTOINC in the help.

The background:
When you use an Identity column in MSSQL Clarion says “Insert this record” but doesn’t include a value for the identity column because the server is going to create it, and in fact will tell you off if you include a value.
So Clarion inserts the record but does not know what the Identity column value is, because it was the server that created it. If it then has to insert a bunch of child records it needs to know that parent identity value. So it asks the server “What was the last identity value you created?”. That asking the server for the last value is what the /AUTOINC setting in the (parent) file declaration does, and is presumably what is not working.
So far as I know nothing has changed between 11 or 12, but maybe somehow you lost the /AUTOINC setting in the dictionary?

37

Yes, thank you for pointing me to /AUTOINC. However, I closely compared the Clarion 11 and Clarion 12 dictionary driver options. All properties and settings match. We have never had to use /AUTOINC before, and hundreds of autoincrement tables (with child records) are in the dictionary. All such tables have the EmulateAutoNumKey=1 property set, and the autoincrement column has External Name “ContactKey | READONLY” (for the previous table mentioned) and the property IsIndentity=True. This has worked well for years.

I will experiment more with /AUTOINC, but at the moment, it is causing other strange problems. The only custom driver setting we sometimes pass is /BUSYHANDLING=2. I turned this off, and the behavior was no different.

Any other suggestions are appreciated.

38

The place where /AutoInc is important is when you have a form to insert a parent that also lets you insert children. If your parents are always fully inserted before you try to insert children for them, then no problem.I assume your problem is with a form where you can insert both parent and children? If not, then you have some other problem priming your child table parentkey.

EmulateAutoNumKey will basically create a “stub” record when you enter the form, so will eliminate one source of potential trouble: trying to add a child when the parent does not yet exist. However, if you look down the help page entitled Server Side Auto incrementing, close to the bottom you will see this:

This associates a column in the dictionary with a Server Side Auto-Incrementing Column. You will also need to add the needed SQL SELECT statement in the /AUTOINC driver string. For example:

/AUTOINC=SELECT LAST_INSERT_ID()

In your case you probably need /autoinc = select scope_identity()

Personally I think whatever problem you have is completely unrelated to the version of Clarion, so you might get more help if you started your own, better-labelled thread.

Jon

39

Thanks, Jon, I will research and test these options.

40

The driver option /AUTOINC is related when Clarion is controlling autoincrement and not the SQL backend—I’m not sure about this, but I’m still looking into it. But note the following testing:

  1. Clarion 11.0.13855 - CLAMSS.DLL - 11/20/2023
  2. Clarion 12.0.13941 - CLAMSS.DLL - 04/25/2025

However, I copied the Clarion 11 SQL driver CLAMSS.DLL into my directory with applications compiled with Clarion 12. The application runs without error when using the Clarion 11 11/20/2023 driver. But, the autoincrement error described earlier occurs when using the Clarion 12 SQL driver CLAMSS.DLL.

41

I definitely recommend you report this to SoftVelocity, if you haven’t already.