Micro Focus Studio Enterprise Edition for Windows > Programming > Data Access > Micro Focus Database Connectors Version 2.0 for Windows > Database Connectors User's Guide > Tutorial: Extending CICS Applications to Use Database Connector for Microsoft SQL Server > Creating the Database Table > Setting Up the Configuration File

Setting Up the Configuration File

Set up a configuration file that instructs Database Connectors on how to operate. In this example, use a project directory of C:\DataConnectors\Test and a configuration file of mssql.cfg.

Create a new textfile called mssql.cfg in your project directory.

Add the following entries to the file:

##################################################
# mssql.cfg
#
# Configuration file for settings to be used in
# conjunction with Database Connectors for MSSQL
#
##################################################

##################################################
# The following is a list of individual assignments
# of files to a filesystem other than the default
##################################################

DBACCTFIL-HOST mssql
XFD-DIRECTORY c:\DataConnectors\Test

##################################################
# Connection information to be used when connecting
# to the target database in Microsoft SQL Server
##################################################

A-MSSQL-DEFAULT-CONNECTION MYSERVER
A-MSSQL-DATABASE testdb
A-MSSQL-LOCK-DB testlock
A-MSSQL-LOGIN testuser
A-MSSQL-PASSWD testpasswd

######################################
# File tracing
######################################

FILE_TRACE 9
FILE_TRACE_FLUSH TRUE
FILE_TRACE_TIMESTAMP TRUE

##################################################
# End of mssql.cfg
#
##################################################

The following table shows the options that you can set in the configuration file:

Variable	Value	Description
DEFAULT-HOST	mssql	Default File System
A-MSSQL-DEFAULT-CONNECTION	<`servername`>	Name of the MSSQL server
A-MSSQL-DATABASE	<`testdb`>	Name of the specific database to be accessed
A-MSSQL-LOCK-DB	<`testlock`>	Name of the database that holds the lock table
A-MSSQL-LOGIN	<`testuser`>	Name under which you want to connect to the database system
A-MSSQL-PASSWD	<`testpasswd`>	Password assigned to the user account
XFD-DIRECTORY	c:\DataConnectors\Test	Directory containing your XFD files if different from current directory
FILE-TRACE	<`any number greater than “0”`>	Level of file tracing to perform