Client Configuration

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

The following section covers the client setup required before you begin using Database Connectors for Microsoft SQL Server (MSSQL) on a new system. The Microsoft SQL Server RDBMS must be installed and configured prior to this, and must be at least version 6.5.

You will also be required to install some stored procedures as part of the client installation. For that you will need something such as Microsoft SQL Server's Query Analyzer or SQL Server command-line tools to run the query that installs the stored procedures.

Note: The default sort order for MSSQL is case-independent. Make sure that this is what you really want when you install the server. The Database Connectors connector uses the sort order as installed and cannot change its behavior to do case-dependent ordering if that is not what the server uses.

First you must install the files from the Micro Focus installation media onto the client machine. Then follow the instructions below for the server machine. Final setup steps on the client machine complete the installation.

Be sure to use the 64-bit libraries with a 64-bit run time system and 64-bit Database Connectors for MSSQL, and the 32-bit libraries with a 32-bit run time system and 32-bit Database Connectors for MSSQL.

Perform the following steps to set up Database Connectors on a new system: