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
- Create a Database Connection
- Start the ADO.NET Connection Editor. If you need instructions, see
To start the ADO.NET Connection Editor as a user.
- On the main screen of the ADO.NET Connection Editor, click
This starts the ADO.NET Connection Editor wizard.
- On the Add an ADO.NET Connection page, click
- In the
Data Source Name field, type
SQLDemo; then click
- On the .NET Data Providers page, select
SqlClient Data Provider; then click
- In the
Data Source field, type
. (dot) to specify your local SQL Server instance.
- In the
Initial Catalog field, type
BookDemo, which is the name of your SQL Server database.
- 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
- If you want to connect by providing SQL Server-specific login credentials, type your SQL Server user ID and password into
Value fields for the
User ID and
Password keys respectively.
Next, and then
- After the new connection appears on the main window of the ADO.NET Connection Editor, click
Test to verify that the connection works.
- Click the
x icon in the upper right corner of the ADO.NET Connection Editor main window to close it.