How to create an ODBC connection?

When using the Microsoft SQL Server or PostgreSQL database systems, an ODBC connection is required for the application server and for the administration toolkit of your BOC product to access its database.

The connection “Database - ODBC Driver - BOC Product” is defined via the ODBC connection name in the [BOC-Product]\conf\server.conf file of your product installation using the # Database connection alias parameter.

This article describes how an ODBC connection can be set up. The procedure differs depending on the database system (Microsoft SQL Server or PostgreSQL).

How to create an ODBC connection to a SQL Server database?​

The following step-by-step instructions show how to set up an ODBC connection to a Microsoft SQL Server database:

Note
Make sure you are using the latest version of the ODBC driver for SQL Server, which can be downloaded directly from the Microsoft website. Please also note that ODBC driver version 18.1 and above is no longer compatible with SQL Server 2012.

Microsoft ODBC Driver for SQL Server is not a BOC Group product, but third-party software. The BOC Group assumes no responsibility for the installation, configuration, or maintenance of third-party software. Please contact an IT specialist at your company to verify the configuration.

Solution steps
Open the tool ‘ODBC Data Sources (64-bit)’
Switch to the System DSN (1) tab and click Add (2).
Select the appropriate ODBC driver (1) for Microsoft SQL-Server and click Finish (2).
Enter a name for the ODBC data source in field Name (1).  It is recommended to choose the name of the ODBC data source identical to the name of the database. Enter the host name or the IP address of your SQL Server in field Server (2). If applicable add the name of the database instance (format: <HOST_NAME>\<INSTANCE_NAME>). Then click Next (3).
Select With SQL Server Authentication (1). Enter the name of the technical database user in field Login ID (2). (By default, this is the username ADOxx.) Enter the Password (3) "r0KaQIFA]cPd2Ave" for the technical database user "ADOxx". Click Next (4).
Check the box "Change the default database to" and fill in the name of the database of your BOC product (1).  Click Next (2).
Click Finish.
Optionally test the connection by clicking Test Data Source (1). Confirm the creation of the ODBC connection with OK (2).

How to create an ODBC connection to a PostgreSQL database?​

How to set up an ODBC connection to a PostgreSQL database is described in the PostgreSQL manual for ADONIS or for ADOIT.