Enterprise Server Service
The Enterprise Server Service functions as a server/listener component. The Enterprise Server Service resides on a non-Windows platform, wrapped into a Windows service. If the data source being accessed resides on Windows, the CONNX driver directly loads the DLLs necessary to establish a direct connection to the data source, eliminating the need for the server/listener architecture that exists for non-Windows datasources such as VSAM, Adabas, or RMS.
The advantages of having the split-stack architecture, even if all components are on windows, include:
The ability to access 32-bit only data sources from a 64-bit client.
Third-party connectivity software (such as the Oracle OCI Client or the SQL Server Driver) only needs to be installed in a single central location, instead of being installed on every desktop where CONNX resides.
In the case of Adabas, if Entire Network is required to access a version of database that does not have a Native CONNX Data Server, Entire Network only needs to be installed on a single central server instead of every desktop.
When CONNX uses the vendor's native database driver to access data, the configuration and setup of those drivers takes place on a single middle-tier server, instead of on each client PC. With the Enterprise Server Service, CONNX seamlessly provides a single client-install solution for data access needs throughout the enterprise.
To run the CONNX Enterprise Server Service, you must first have selected the Enterprise Server Service check box in the Select Components window during installation of CONNX.
When the CONNX Data Dictionary Manager window appears, select a database from the list.
Then, in the Database Info tab, check the Use Enterprise Server check box in the Enterprise Server Service group box. Enter the name or IP address of the computer running the CONNX Enterprise Server Service in the Server text box. Specify the port number for the server you intend to connect to in the Port text box for the CONNX Enterprise Server Service. The default port number for the client to connect to the server is 6500.
By selecting the Use Enterprise Server option for a given database, CONNX performs all database access through that remote server. For example, if using CONNX to access SQL Server and Oracle, by selecting Use Remote Server, the SQL Server OLE DB Provider and Oracle Net Client only need installation on the single PC running the CONNX Enterprise Server Service. All other PCs in the organization require the CONNX driver only. Installation of a third-party driver or other network components is not required.