Initial Setup instructions for DCE Server via SOCKETS

To set up the ExonetDCE for connection via SOCKETS you need to set up the DCE server following:

Prepare Executables

1. Decide on a location for your executables.
   While you can set up the executables anywhere you want, most Exo sites are configured in a C:\Exonet folder and this is where consultants are likely to look for it.
2. Copy ExonetDCE.exe to the MYOB Exo Business folder This can be founded in EXECUTABLES.ZIP. The current version at time of this article being published is: 2020.3 version of Executables.zip
3. Download COMPONENTS.ZIP for your version of Exo. The current version at time of publishing is: 2020.3 version of COMPONENTS.ZIP
4. Copy the newest version of scktsrvr*.exe into your EXO folder
5. Rename the file to scktsrvr.exe (remove the version information)
6. Copy the newest version of midas*.dll into your EXO Folder.
7. Rename the file to midas.dll (remove the version information)
8. Open a command prompt with administrator privileges, and navigate to your Exo folder (Eg: C:\Program Files (x86)\MYOB Exo Business or C:\Exonet)
9. Type scktsvr.exe /install
   This registers the required Sockets driver.
10. Type ExonetDCE /regserver
    This registers the DCE Service in the registry.
11. Type ExonetDCE /install
    This adds ExonetDCE to the Services list for Windows.
12. Type Regsvr32 midas.dll
    This registers MIdas.DLL as available for applications to use (Datasnap).
13. Install the MS OLEDB driver for SQL Server. You can find this direct from Microsoft.

Configure Windows Services.

1. Open the Windows Services Manager in Window's Administrative Tools
2. Locate the “Borland Socket Server”. Ensure the Startup Type is set to Automatic. (We also recommend changing the Restart options to always restart the service.)
3. Right click the service, and click Start.
4. Locate the “EXO Business DCE”. Ensure the Startup Type is set to Automatic. (We also recommend changing the Restart options to always restart the service.)
5. Right click the service, and click Start.
   

Configure Distributed COM Server Permissions

1. Open the Component Services Manager in Windows Administrative Tools (DCOMCNFG.EXE)
   

   

   

   The actual applications visible in the DCOMCnfg properties will depend on the applications installed on your server. Note the Exo Business DCE application in the list.

2. Open Component Services > My Computer > DCOM Config, right-click on the Exo Business DCE application and select Properties.

   

   You may see Exo Business DCE in the list multiple times. In that case repeat Steps 3-8 for each instance.

3. Select the Security tab.
   

   

   
   Access permissions must be for the server DCOM objects so the client computers can access the middleware server. Launch and Configuration permissions should be left as default as they are not used when the Exo Business DCE is run as a service.
4. In the Access Permissions group, select Customize and click the Edit.. button.
   

   

5. When the Access Permission window appears, click Add..

   

   For purposes of testing if the service can work, it can be useful to try the EVERYONE special user group. This is not recommended for live environments as it opens up the security too far, but is useful for testing connections.

6. Add the SYSTEM account.
7. Ensure that the Allow is ticked for the access permissions for the user(s).
8. Click OK and close all Windows.

Configuring ExonetDCE

1. Open a Command Prompt in Administrator mode.
2. Run ExonetDCE in -Executable mode
   Type ExonetDCE.exe -Executable
3. You'll now see this icon in your system tray:

   

4. Right click and choose: Setup Connections
   

   

5. The usual Exo Business Connection Editor will appear. Add a connection configured to your server:
   
   

   

6. After configuring the connection, Save and then Test it.
7. If you see the message
   "Unable to connection to DB_NAME
   The Error message is:
   Missing data provider or data packet.
   The above message is a false error and indicates a successful connection in version 2020.3 of the ExonetDCE.

Everything to do with DCE Configuration should be referred to either your IT Administrators or your Exo Business Implementation Partners. These pages are highly technical and intended for your Partner to work through.

You can also find more resources on the MYOB Exo Business Education Centre.