Set Up the OESQLAsst Project

Walks you through the steps required to create and configure a Visual Studio project to use for this tutorial.

Create a Visual Studio project

This tutorial requires that you create a COBOL project where you store, build, and run the COBOL application that you create later in this tutorial using the OpenESQL Assistant. In doing so, you use features available in the ADO.NET connection editor and the OpenESQL Managed Runtime.

In Visual Studio, click File > New > Project.
In the New Project dialog box, expand Installed > COBOL.
Click the Windows Desktop category.
Select Console Application (.NET Framework).

Complete the fields as follows:

Name	`OESQLAsst`
Location	c:\tutorials\SQL
Framework	Choose the appropriate .NET Framework version from the drop-down list. Note: Must be .NET Framework 4.5 or higher.

Click OK.
Visual Studio creates a new solution and a project named OESQLAsst. The project contains one generic program, Program1.cbl, that you use in a later tutorial. If Visual Studio has automatically opened this file for editing, close it for now.

Set project properties

To compile this application such that it connects to the database via ADO.NET, you must set the project properties to include the DBMAN=ADO SQL compiler directive option. We must also set the BEHAVIOR compiler directive to provide optimal cursor behavior, including isolation level and lock concurrency settings.

From the Solution Explorer, double-click Properties under your OESQLAssistantTutorial project.
On the SQL tab, select OpenESQL from the ESQL Preprocessor drop-down list.
Click Add.
On the Available Directives list, click DBMAN; then click OK.
Repeat steps 3 and 4, but this time add the BEHAVIOR directive.
Back on the SQL tab, select BEHAVIOR on the Directives list.
From the Value drop-down list, select ANSI.
Click Save (); then close the Properties window.