Prerequisites

The following prerequisites are required before moving on to the OpenESQL Managed Code tutorials.

• The Microsoft Visual Studio Shell does not support the generation of clients. Therefore, you must use a full installation of Visual Studio.
• Microsoft SQL Server must be installed on the same machine as Visual COBOL. For a list of the SQL Server versions tested with OpenESQL, see the Database Access - OpenESQL section in Additional Software Requirements.
• Complete the procedures outlined in Prepare the BookDemo SQL Server Database below.

Prepare the BookDemo SQL Server Database

All OpenESQL Managed tutorials use the same SQL Server database, named BookDemo. Here you create the database and a database connection, but you populate it on an as-needed basis depending on the tutorial. Each tutorial provides instructions for populating the required tables.

Create the BookDemo Database

• Using SQL Server Management Studio or another preferred method, create a SQL Server database named BookDemo.
  Note: The user ID and password you provide must log you on to SQL Server with dbadmin or sysadmin permissions that enable you to create a SQL Server database.

Create a Database Connection

1. Start the ADO.NET Connection Editor. If you need instructions, see To start the ADO.NET Connection Editor as a user.
2. On the main screen of the ADO.NET Connection Editor, click Add.

   This starts the ADO.NET Connection Editor wizard.

3. On the Add an ADO.NET Connection page, click Next.
4. In the Data Source Name field, type SQLDemo; then click Next.
5. On the .NET Data Providers page, select SqlClient Data Provider; then click Next.
6. In the Data Source field, type . (dot) to specify your local SQL Server instance.
7. In the Initial Catalog field, type BookDemo, which is the name of your SQL Server database.
8. Do one of the following to set authentication for your SQL Server instance:
   • If you want to connect using Windows authentication (recommended), change the value for the Integrated Security key to True.
   • If you want to connect by providing SQL Server-specific login credentials, type your SQL Server user ID and password into the Value fields for the User ID and Password keys respectively.
9. Click Next, and then Finish.
10. After the new connection appears on the main window of the ADO.NET Connection Editor, click Test to verify that the connection works.
11. Click the x icon in the upper right corner of the ADO.NET Connection Editor main window to close it.