2022.1

l When MS SQL is selected, the default values for root user are sa and 1433 for the port.
l If database settings from a previous OLConnect installation are found, the pre-exising
settings will be displayed for the matching database type. For MS SQL settings, this will
only work if they were created with Server Config Tool 1.5.0 or later, or the Installer for
OLConnect 1.6.0 or later.
If the database type is changed in the Installer configuration page, the default values for
this database type will be displayed.
If the pre-existing database settings are set to Hsqldb, the default database type selection
will be MySQL.
l Selected database settings are stored in the preferences, and can be found in this file:
C:\ProgramData\Objectif Lune\OL
Connect\.settings\ConnectHostScope\com.objectiflune.repository.eclipselink.generic.pref
s
When modifying Connect
l If the local MariaDBis removed from an installation, the Database Configuration page will
offer additionally the Microsoft SQL Server database type with respective default values.
l If local MySQL is added to an installation, the usual MySQL Configuration page with
default values will be displayed.
If the user has installed the Installer Supplied MySQL and then switches to an external
Microsoft SQL by using the Server Configuration Tool, the supplied MySQL cannot be switched
off. By design the installer adds a service dependency between Connect Server and the
supplied MySQL service.
Note
The Microsoft SQL selection capability will be available only with 1.6 version and
upwards.
To remove this dependency the user needs to do the following
1. Have a foreign Microsoft SQL running, ready for use with Connect Server.
2. Use the Server Configuration Tool "Database Connection preferences" on page895 to
switch the database to Microsoft SQL.
3. Re-start the Connect Server Service, so that the modifications become active.
Page 21