Tutorial: Prepare the SQL CLR Environment

Provides step-by-step instructions that walk you through the process of setting up the environment required to use SQL CLR stored procedure functionality with HCO for SQL Server, and additional setup tasks required to complete the remaining SQL CLR stored procedures tutorials.

Prerequisite

If you have not already done so, review the Assumptions and Before you begin a tutorial sections in the Tutorials: HCO for SQL Server (HCOSS) topic to ensure your Enterprise Developer environment is set up properly.

Sequence

To complete this tutorial, progress through these topics in the order presented here. The bottom of each topic provides Next topic and Previous topic navigational links to help you proceed in the proper sequence:

  1. Enable SQL CLR Integration
    Takes you through the process of enabling the SQL CLR Integration feature in Microsoft SQL Server.
  2. Create the SQLCLR_Test Database
    Provides instructions that enable you to create the SQLCLR_Test database and populate the database with the data used by these tutorials.
  3. Create an ODBC 32-bit System Connection
    Walks you through the process of creating an ODBC connection to use when completing these tutorials.
  4. Build the ODBC XA Switch Module
    Guides you through the process of configuring your machine to build the ODBC XA switch module used in these tutorials, and then building the module.
  5. Import 32-bit JCL Enterprise Server Regions
    Provides step-by-step instructions for importing the two provided enterprise server regions required to complete these tutorials.
Parent topic: Tutorials: Calling SQL CLR Stored Procedures in an SPD File
Related concepts
Tutorials: HCO for SQL Server (HCOSS)