2022.2

Table Of Contents

Note: SincePlanetPressConnectversion1.6theminimumrequiredversionoftheMSSQL

ServerisSQL Server 2012.

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data-

base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 Con-

nect\.settings\ConnectHostScope\com.objectiflune.repository.eclipselink.generic.prefs

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MariaDBisaddedtoaninstallation,theusualMariaDBConfigurationpagewithdefault

valueswillbedisplayed.

IftheuserhasinstalledtheInstallerSuppliedMySQL(2021.2orearlier)orMariaDB(2022.1andlater)

andthenswitchestoanexternalMicrosoftSQLbyusingtheServerConfigurationTool,thesupplied

localdatabasecannotbeswitchedoff.BydesigntheinstalleraddsaservicedependencybetweenCon-

nectServerandthesuppliedMariaDB\MySQLservice.

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787toswitch

thedatabasetoMicrosoftSQL.

3. Re-starttheConnectServerService,sothatthemodificationsbecomeactive.

4. CountercheckthateverythingisworkingproperlywithMicrosoftSQL.

5. Openacommand-linepromptwithfulladministrationrights.

6. Enterthecommandsc config OLConnect_Server depend= /.Thisremovesthedepend-

ency.

Page 18