Simplicty and flexibility!


Knowledge::

Installing DataEase 7.x on Citrix Server


Parameters


Returns/Result


Examples


Reference

 Installing DataEase 7.x on Citrix Server

Environments: 
MS 2003 Server;
Windows Server 2008 32-bit.

1. Install DataEase 7.x on Citrix Server (this effectively becomes multiple-workstations and should be treated as such);

2. Make sure ‘FILES=100’ is set in the’ \WINDOWS\SYSTEM\CONFIG.NT’ file on the Citrix sever;

3. Alter/add the following registry settings as though you were dealing with a workstation;

The following are all of type DWORD:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanManWorkstation\Parameters

  • UtilizeNTCaching=0

    UseUnlockBehind=0

    UseOpportunisticLocking=0

    UseLockReadUnlock=0


NOTE: If you are going to use load balancing across several CITRIX servers then points 1 to 3 need to be repeated on each CITRIX box.

4. Put the database in a separate directory on the server;

5. Create a named share to this database directory;
 

6. Create a CITRIX / MS User Group for the application;

Give the group:

  • a. READ & EXECUTE rights in the DataEase program directory on the CITRIX Box(s);

    b. MODIFY, READ & EXECUTE, READ, WRITE rights in the ‘Share’ that holds the Database directory.


7. Create all users for the application and add them to the group created above;

8. On the Database Server, alter/add the following Registry settings:

They are all of type DWORD.

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanManServer\Parameters

  • CachedOpenLimit=0

    EnableOpLocks=0

    OpLocksDisabled=1

    UtilizeNTCaching=0

    UseUnlockBehind=0

    UseOpportunisticLocking=0

    UseLockReadUnlock=0


Note: All servers need rebooting before the individual registry settings become active on that particular machine;


Tests to make sure that it is working correctly:

1. Login to a Citrix application session as more than one of the users in the group on separate machines;

2. Login to the Database.

  • a. Test record locking is working correctly in record entry. Enter / Modify / Delete.

    b. Test record caching is not occurring (server registry settings).

    c. Test a form/report that contains lots of relationships. (Files = 100).


3. Look in file RDRRxxxx.ssn of the application folder. This file should be storing the logged in users/machine names.

 

See Also


On the forum about Installing DataEase 7.x on Citrix Server

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

How can i delete a Style sheet?...

Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10

I run W7 and since a few days&nbsp;Dataease 8.5 is not starting any more, do you have an idea? i installed it again but that did not help....

Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40

[@EOF@]...

Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10

On the blog about Installing DataEase 7.x on Citrix Server


dg3_HelpView