Skip to main content

Keyword not supported: 'driver' error when installing B&OM


Question / Problem: 

When installing KCM, you receive the following error when Batch and Output Management installs:

==== Execute: D:\InstallServer\Scripts\Output Management.ps1 "Accept"
D:\InstallServer\Scripts\Output Management.ps1
Target: Output Management
Stage = "Accept"
D:\InstallServer\Software\ITP Server\Bin\checkdatabase32.exe exists
D:\InstallServer> "D:\InstallServer\Software\ITP Server\Bin\checkdatabase32.exe" ... silent arguments.
Checking Database failed:
Error while connecting to SQLServer database
Keyword not supported: 'driver'.
DisplayCheckDBErrorAndExit : checkdatabase problems: Cannot check permissions with 'Driver=<SQL Driver used>;Server=<DB Server>;Database=<DB Name>' for user '<DB User>'.
At D:\InstallServer\Scripts\Tools\Functions.ps1:521 char:9
+ DisplayCheckDBErrorAndExit $ExitCode $ConnectionString $UserF ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,DisplayCheckDBErrorAndExit


Answer / Solution: 

In comparison to the connection string provided for the KCM Repository installation, which is an ODBC connection string, the string provided for B&OM installation (Repository and Runtime DB) is NOT an ODBC connection string, as mentioned in the manual.

This means that the "Driver=" parameter is not supported and needs to be removed. This also can be seen in the examples given in the Installation Guide, page 22:

The parameters would then be:

OMRepositoryDB!ConnectionString="Server=<DB Server>;Database=<OMRepository DB Name>"

OMRuntimeDB!ConnectionString="Server=<DB Server> ;Database=<OMRuntime DB Name>"

Applies to:  

Product Version
KCM 5.4