2020-1

Table Of Contents
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
OLConnect 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
Updating With No Local MySQL Product
l When updating a Connect installation from 1.5.0 which contains a Server Product but no
local MySQL Product, the Database Configuration Page will detect which database type
was set before (especially if the database configuration was switched from MySQL to MS
SQL using the Server Configuration Tool), and default to those settings.
l On Update from 1.4.2 or earlier, the Database Configuration Page will always default to
MySQL connection settings, and if the installation was manually tweaked to connect to
MS SQL Server, the user has to switch to "Microsoft SQL Server" type and enter
connection details again.
When modifying Connect
l If local MySQL 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.
Page 14