Samples: SQL Server Connection String Exit Programs

The sample SQL server connection string user exit can be found in %PUBLIC%\Documents\Micro Focus\Enterprise Developer\samples\Mainframe\CICS\DotNet\SQLEXIT

This exit can be called by Enterprise Server for .NET to obtain the connection string to use for user SQL connections.

• sqlexit.cbl and the project sqlexit.cblproj

  This sample exit program uses the MicroFocus.SEE.UserExit.IConnectionStringExit.GetConnectionString() method with no parameters to retrieve the connection string for the user SQL database. Use this exit when a single CICS region uses the exit program.

  The connection string this sample program returns is

  Data Source=(local);Initial Catalog=master;Integrated Security=SSPI

• sqlexit2.cbl and the project file sqlexit2.cblproj:

  This exit uses the MicroFocus.SEE.UserExit.IConnectionStringExit2.GetConnectionString() method that takes parameters to retrieve the connection string for the user SQL database by specifying the database server instance and region names. This exit is typically used when multiple regions use the exit program.