Set Up the JCLSPMDN Enterprise Server Region

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

Start Enterprise Server Administration

  • On the Visual Studio Server Explorer, right-click Micro Focus Servers, and select Administration from the context menu.

    The Enterprise Server Administration Home page starts in an Enterprise Developer window.

Add configuration information

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

  1. On the Enterprise Server Administration Home page, click the Edit button that corresponds to the JCLSPMDN enterprise server region.

    By default, this takes you to the Server > Properties > General page.

  2. In the Configuration Information field, add the following:
    [ES-Environment]
    JCLPROJ=C:\tutorials\SQLCLR\MultiProjDataName\SPCall
  3. Click Apply.

Configure the CALLSP XA resource

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

  1. Click the XA Resources tab.
  2. Click the Edit button that corresponds to the CALLSP XA resource name.
  3. Ensure that the Module field is set to the fully expanded path to the ESODBCXA.dll file, which by default is 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 OK to save the changes.
  6. Close the Enterprise Server Administration Home page window.