Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Unable to debug into the Cobol SQL CLR stored procedure

Unable to debug into the Cobol SQL CLR stored procedure

Problem

When trying to debug into the Cobol SQL CLR stored procedure, you may get the errors below:

1. Get error "Unable to debug .NET code. Could not attach to SQL Server process on xxx".

2. The debugger just steps over the EXEC SQL CALL statement, you cannot step into the stored procedure.

Resolution:

For the first error, you need to run Visual Cobol for Visual Studio as administrator.

For the second issue, please double check the following:

1. The Calling program's project property, debug tab, the Enable SQL Server debugging option is set.

2. In Visual Studio SQL Server Object Explorer, right click the SQL Server instance, and ensure that the Allow SQL/CLR Debugging option is checked.

3. If you have rebuilt the SQL Server Database Project, you need to re-Publish the stored procedure to SQL Server before starting debugging.

Please check Tutorials: SQL Server COBOL Stored Procedures in our documentation for step by step procedure on how to work with Cobol SQL CLR stored procedures.

 

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2015-11-05 16:44
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.