Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
15
Erster Beitrag:
vor 1 Jahr, 7 Monaten
Letzter Beitrag:
vor 1 Jahr, 6 Monaten
Beteiligte Autoren:
Sammy Broeders, Arie, Joris, Yogi Yang, Fabrice Harari

Windev 20, System error code: 1224

Startbeitrag von Sammy Broeders am 25.03.2016 14:16

Hello,

I have a Multi-user, Windev 20 applications. By some users i have sometimes this error;
System error code: 1224
System error message:
Kan de aangevraagde bewerking niet uitvoeren op een bestand met een open door de gebruiker toegewezen sectie.


The program is local on the C: drive of each pc and the data is on a network drive.

Any idea what this error means?

Antworten:

Hi Sammy

are you telling us that you are working in HF classic through network?

If that is the case, switch to HF CS to avoid oplock problems.

Best regards

von Fabrice Harari - am 25.03.2016 14:37
Hello,

I have had the same kind of problem but in my case the application hangs.

From what I have understood. It may be due to data corruption or record locking conflict.

HTH

Yogi Yang

von Yogi Yang - am 25.03.2016 14:40
Thanks for the reply.

It is HF classic, is it easy to switch to HF cs?

von Sammy Broeders - am 25.03.2016 15:41
Hi Sammy,
quite easy.
1. Install HFSQL
2. create a submap in map holding all hfsql databases (the BDD map by default)
3. copy all classic files into the submap
4. add a few lines of code to your application

MyConnection is Connection
MyConnection..User = "ADMIN"
MyConnection..Password = ?? // no password by default for ADMIN
MyConnection..Server = "ip or dns" // i.e. 192.168.1.2:4900
MyConnection..Database = "YourDatabaseName" //name of the submap in BDD
MyConnection..Provider = hAccessHFClientServer

HOpenConnection(MyConnection) // Open the connection
HChangeConnection("*.*", MyConnection)

I read all setting from an inifile btw, so I can change them very easy without the need to change the application

von Arie - am 25.03.2016 16:41
Thanks Arie, i will try the convert to HFcs.
So the install of HFSQL is necessary by all the users?

von Sammy Broeders - am 26.03.2016 08:25
I have now make a data server from my local pc, but where can i find the real data files?

von Sammy Broeders - am 26.03.2016 11:03
Sammy,

no, you have to install hfsql only once on a central server, where the data sits. (or even use ONE of client computers as a "server"- I have POS application where one pc is acting as a server and client, servering other POS systems in the network). Communication between client and server goes over a tcpip port, nothing else. (4900 by default)
This means port 4900 must be open (in the firewall) of course. But on an internal network that should be no problem, most of the time that's already the case while internal firewalls are disabled.

If you have a stand alone development machine (so you have the rights to install things), you can try this first for yourself. Use myconnection..server = "localhost:4900"

von Arie - am 26.03.2016 11:09
When you install HFSQL the map is mentioned somewhere. Afaik it in the %%COMMONAPPDATA%% map. But it's always a problem to know where this folder exactly is. (c:\programdata ??)
You can also change the location afterwards in a file called hfconf.ini, to be found in the hfsql installation map.

von Arie - am 26.03.2016 11:14
Arie,

First thanks for the support!

My database directory is: %%COMMONAPPDATA%%\PC SOFT\HFSQL server_SaBroSoft-2\BDD

Is the BDD a map on the pc?

von Sammy Broeders - am 26.03.2016 15:59
Yes BDD is a map. A HFSQL can server many databases. Every database has a submap under BDD, holding all the fic,ndx and mmo files. The files are exactly the same as in classic mode, that's the reason why you can copy them.
In hfsql mode the client does not access these file directly, but is talking to the hfsql engine. And the engine does the read/rwite to these tables.
This is how all C/S database work, like mysql and Micrsot sql-server and Oracle. The engine sits in between.

From a Microsoft site:

Windows XP and Windows 2000
C:\Documents and Settings\All Users\Application Data

Windows 10, Windows 8.1, Windows 7, and Windows Vista
C:\ProgramData

von Arie - am 26.03.2016 16:52
Thanks Arie!

It works fine. So it is not necassary to change the type of data file from classic to client/server in my project analyse?

von Sammy Broeders - am 29.03.2016 16:29
Sammy,
no need for a change.
And I believe is was Guenter who explained in another post it is best to have all datafiles defined as HF-CLASSIC in the analysis.
And switch during runtime, on opening the database.

Because you are coming from hf-classic, I think you are done now :rp:

von Arie - am 29.03.2016 16:38
Hi,

Indeed, if you are defining the database connection by code, i would absolutely recommend to keep your files (even the future ones) in 'classic' in the analysis.

Regards,

Joris.

von Joris - am 30.03.2016 12:08
Ok nice, then i can keep my temp and local files out of the CS.

Thanks all for the good support!

von Sammy Broeders - am 30.03.2016 19:26
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.