Catalog the SQLServerDB Connection

Guides you through the process of starting the ADO.NET Connection Editor and cataloging the SQLServerDB connection.

Start the ADO.NET Connection Editor

  • From your Windows Start menu, select Micro Focus Visual COBOL > ADO.NET Connection Editor.

Catalog the SQLServerDB Connection

  1. On the main window of the ADO.NET Connection Editor, click Add. This starts the Add an ADO.NET Connection wizard.
  2. Click Next.
  3. In the Data Source Name field, type SQLServerDB, which is the name of your connection, and then click Next.
  4. In the .NET Data Providers grid, select SqlClient Data Provider, then click Next.
  5. Modify the following fields on the Connection Settings grid, providing the specified values:
    Field Value
    Data Source (local)
    Initial Catalog SQLCLR_Test
    Integrated Security True
  6. Click Next to review your settings.
  7. Click Finish to add the new connection. This returns you to the main window.
  8. After the Data Source Names list refreshes, select the SQLServerDB entry.
  9. Click Test to ensure the connection works properly; then click OK to clear the message.

Close the ADO.NET Connection Editor

  • To close the ADO.NET Connection Editor, click the Close button button in the upper right corner of the main window.
Parent topic: Tutorial: Prepare the SQL Server COBOL Environment