- In
Enterprise Developer, open a
SQL Server Database Project solution that contains a SQL CLR stored procedure.
- From the Solution Explorer, open the project properties for the COBOL project.
- On the
SQL tab, set the DBMAN directive to
ADO.
- Ensure that the BEHAVIOR compiler directive option is set to MAINFRAME for optimized performance.
- Open the project properties for the
.Publish project.
- On the
Project Settings tab, set the
Target Platform to the version of Microsoft SQL Server that you are using.
- On the
Debug tab, click the
Edit button associated with the
Target Connection String.
- In the
Server Name field, type
. (dot) to indicate a local SQL Server instance, type the name of a SQL Server instance, or select an instance from the drop-down list.
- In the
Select or enter a database name field, type the name of a SQL Server database, or select one from the drop-down list.
- Click
OK to save the new connection string.
- Save the solution.
- Right-click the
.Publish project in your solution, and select
Publish.
- On the Publish Database dialog box, click
Edit.
- In the
Server Name field, type
. (dot) to indicate a local SQL Server instance, type the name of a SQL Server instance, or select an instance from the drop-down list.
- In the
Select or enter database name field, type the name of a SQL Server database, or select one from the drop-down list; then click
OK.
- On the Publish Database dialog box, click
Publish. When the publishing process is complete, the Data Tools Operations window shows a status of
Publish Completed Successfully.
Note: If you make changes at a later date, you can update the project using the
Add SP to SQLCLR option from the context menu in the OpenESQL Assistant.