Cobol ODBC access to SQL Server 2005

[ecichy]

I am using CA Realia Cobol Workbench 3.3 to access Microsoft SQL Server 2005 via Embedded SQL and ODBC. I am having a problem with executing a stored procedure with output parameters. I have tried many different formats of the call to the stored procedure with no success. I can get stored procedures to run and exectute properly with input host variables. I can also get the stored procedure with the output host variable to execute, but the host variable is not populated with the expected results. I've gotten around this by using a cursor to execute the stored procedure and then fetching my single row result from the cursor. Trying to figure out if this is an SQL Server ODBC issue or an execution format issue. I'll start on this forum and move to the Cobol forum if need be. I'll get into program and stored procedure code if someone is interested.