Setting Up the User Environment

To set up your user environment to use Database Connectors, the most convenient method is to populate an ACUFH configuration file with the configuration variables to suit your requirements; you can make a personalized copy of the ACUFH configuration file and set the A_CONFIG variable to point to this. Populate this file with the variables as detailed in ACUFH Configuration File Variables.

Alternatively, if you do not use a configuration file, you must set each required variable directly in the environment, either from the command line or programmatically.

Whichever method you use, you must at least set the valid user login details for your SQL Server. These are A_MSSQL_LOGIN and A_MSSQL_PASSWD. Alternately, you can set the configuration variable A_MSSQL_NT_AUTHENTICATION to TRUE.

Tip: For security reasons, we recommend setting A_MSSQL_PASSWD from your COBOL program, by prompting for a password and then executing:
 SET ENVIRONMENT "A_MSSQL_PASSWD" TO user-entry

On UNIX/Linux platforms, you should also ensure that the A_MSSQL_ODBC_DRIVER_NAME variable is set. This needs to be set to the exact name as specified in the odbcinst.ini configuration file used by the driver manager.