contents.gifindex.gifprev1.gifnext1.gif

Microsoft SQL Server: Setting Up the User Environment

The user's account should have been set up correctly to access the Microsoft SQL Server RDBMS system. This includes environment variables such as DSQUERY. See your Microsoft SQL Server documentation for more details.

In addition to setting the variables required for Microsoft SQL Server, you will need to do the following:

* Ensure that your execution path contains the name of the directory where you placed your newly linked Acu4GL runtime executable.

* Set the A-MSSQL-LOGIN and A-MSSQL-PASSWD variables, either in your environment or in the ACUCOBOL-GT runtime configuration file (if you don't do this, Acu4GL will use the value of the USER environment variable as your Microsoft SQL Server login name, with no password). For security reasons, it is best to set the password variable from your COBOL program by asking the user to enter a password and then executing:

SET ENVIRONMENT "A-MSSQL-PASSWD" TO user-entry

Non-4.1 sites using Windows should also set the variable A-MSSQL-PID, to give each user a unique value for locking records.

You may want to make and use a personalized copy of the configuration file to avoid impacting other users. The ACUCOBOL-GT User's Guide describes how to use the A_CONFIG environment variable, or the -c runtime option, to identify a personal configuration file.

For detailed information on A-MSSQL-LOGIN and A-MSSQL-PASSWD, see Microsoft SQL Server: Configuration File Variables .