You will find SuperOffice.config in
- your SuperOffice server installation folder [server_inst]\SuperOffice
- and if Windows client is installed: in your locale SuperOffice folder on each of the clients, default: C:\Program Files\SuperOffice\SuperOffice Windows. The file will be “copied” (settings are transferred over) from the server’s SuperOffice.config / SuperOffice.ini while installing.
Application configuration files
An application configuration file is an XML file used to control assembly binding. It can redirect an application from using one version of a side-by-side assembly to another version of the same assembly. This is called per-application configuration. Application configuration files contain settings specific to an application. This file contains configuration settings that the common language runtime reads (such as assembly binding policy, remoting objects, and so on) and settings that the application can read. The configuration file for an application hosted by the executable host is in the same directory as the application. The name of the configuration file is the name of the application with a .config extension. For example, an application called myApp.exe can be associated with a configuration file called myApp.exe.config. The settings you set in SuperOffice.config is transferred over to ‘appname’.exe.config. They are essentially the same files. The reason ‘appname’.config exists is because when the executable is run, its config file is simple the executable’s name with a.config suffix.
Database connection
Database connection details are in SuperOffice.config. Some parts of S&M use the ODBC connection to the database, configured in the SuperOffice.ini file, and some use the NetServer as the connection to the database, configured in the SuperOffice.config file. If Oracle SQL server is used, there are extra config settings in SuperOffice.config that tell the client where to find the Oracle drivers.Oracle settings
In SuperOffice.config, you do not need to specify theDynamicLoadedConnectionType and location of the Oracle driver DLLs, if they are properly installed and can be found by our algorithms. However you can specify them, and those specifications will be used.
On the other hand, the Server and Database specifications are always overridden, both in-memory in the Win client and when writing the config file for the MailLink. The override is based on the registry settings created by the Oracle ODBC client setup, not on whatever values may be in the SuperOffice.config file; and Database will always (correctly) be set to blank since it is not used by the connection string.
We have a multilevel algorithm to pick up the Oracle drivers. This is run no matter what so it should therefore work successfully at the customer without this info in the SuperOffice.config.
The SuperOffice configuration for Oracle is constructed as follows:
-
The Win client reads registry information about the Oracle driver ODBC setup; notably the
ServerNamevalue. - This server name overrides the SuperOffice.config file.
-
Database name is hard-set to blank; since the substitution variable
[@Database]is not present in the configuration string that value would not have been used anyway. -
We set
DynamicLoadedConnectionTypeto Oracle.DataAccess.Client.OracleConnection set major version to Oracle and minor to 11; then we analyze registry settings to locate the Oracle Home and look for driver files there (based on ODP.NET or ORACLE sections, in current user and local machine; in that order).
- The
ServerandDatabasesettings in the SuperOffice.config file are always overwritten. Serveris based on the registry information from the ODBC setup, whileDatabaseis not used and set to blank.
ArchivePath is gone, cause we read this from SuperOffice.ini.
If impersonating is true then they need to update the info here along with the info for dbuser and dbpassword.
System user
The system user is defined in the<SuperOffice><Data><Explicit> section.
We do not allow the previous default naming of the standard user, like “CRM7” and password any similar to the CRM 7 default password. You will be prompted at the upgrade to change the system user if you do.
Enable debug
For enabling logging and setting logpath, see Enable debug.Use a seperate SuperOffice.config
To specify and use a separate SuperOffice.config, see/INIPATH in Command line switches.