We use Appeon infomaker 2019 and have a connection to a MS SQL database (tried ODBC and SNC SQL Native Client) We can make queries and reports, but when we want to call an Stored Procedure in MS SQL server (which works perfect in microsoft SQL server management studio without errors or other messages) we get the error message in the infomaker report:

"Select Error: Requested result set number 1 not found."

When I make a call to the stored procedure in Infomaker  (new\object\tabular\stored procedure) and I select the procedure in the list, without manual creating an result-set, it also gives me the same error message.

I created a very simple stored-procedure only to get this working like so:

USE [SI_DEVELOP]
GO
/****** Object: StoredProcedure [dbo].[Test_string] Script Date: 16-3-2023 11:21:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Test_string]
-- Add the parameters for the stored procedure here
@S1 varchar(100), @S2 varchar(100), @S1_2 varchar(100) OUTPUT
AS

BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.

-- Insert statements for procedure here
SET NOCOUNT ON

SET @S1_2 = @S1 + @S2
END

All help is welcome because I got stuck with this...