Set Up the JCLSPMDN Enterprise Server Region

Walks you through the process of configuring the imported JCLSPMDN enterprise server region for use with this tutorial.

Start the Server Explorer

The Server Explorer expandable ribbon is visible in Visual Studio on the top left side of the IDE by default when using Enterprise Developer. However, if it is not visible:

  • In Visual Studio, click View > Server Explorer.
Attention: You might encounter an Enterprise Server Sign On dialog box as you perform the steps required to create, configure, start, or stop an enterprise server region from the Server Explorer. If you do, ensure that the Server requires credentials, Use specific server credentials, or Server is secured box is unchecked, and then click OK. Also, if prompted to disable password recovery, click No.

Start Enterprise Server Common Web Administration (ESCWA)

  • On the Server Explorer, right-click Micro Focus Servers, and then click Administration.

    ESCWA starts in your default browser.

Add configuration information

In this section, you add an Enterprise Server environment variable, JCLPROJ, that points to your SPCall project subdirectory.

  1. In ESCWA, click Native.
  2. In the navigation pane, click Directory Servers > Default > JCLSPMDN.

    This opens the General Properties page for the JCLSPMDN server.

  3. In the Configuration Information field, add the following:
    [ES-Environment]
    JCLPROJ=C:\tutorials\SQLCLR\MultiProjDataName\SPCall
  4. Optionally, you can add a description for the JCLSPMDN enterprise server region. To do this, in the Description field, type a description of the new enterprise server. For example, SQL CLR Tutorial SPMDN.
  5. To save the changes, click Apply.

Configure the CALLSP XA resource

Now you configure the CALLSP XA resource to point to the ESODBCXA.dll module:

  1. Click General > XA Resources.

    This displays the XA Resources table.

  2. Click Edit in the row that corresponds to the CALLSP XA resource name.

    This opens the XA Resource Configuration dialog box.

  3. Ensure that the Module field is set to the absolute path for the ESODBCXA.dll file, which by default is located at C:\Program Files (x86)\Micro Focus\Enterprise Developer\src\enterpriseserver\xa\ESODBCXA.dll.
  4. If you are using SQL Server authentication for your ODBC connection, edit the Open string field to append the USRPASS parameter to the open string so that it reads as follows:
    DSN=SQLCLRTutorial, USRPASS=userid.password

    Where userid.password is the user ID and password used to log onto SQL Server.

    If you are using Windows authentication, skip this step.

  5. Click Save.
  6. You can now close ESCWA.