AnsweredAssumed Answered

RDBMS calling stored procedure with group distribution

Question asked by helbigm on Aug 13, 2020

Hi all,

 

We are facing a problem combining group distribution in combination with calling a stored procdure with parameter. We try to use placeholders to exceute the stored procedure remote.

 

The testsetup is like this:

- Reply of the procedure

- Tag Configuration

- RDBMS Version 3.23.10

- Connection via ODBC to MSSQL established

- SQL Statement "File.sql" in instrument tag:

{CALL [XXX].[dbo].[sp_storedprocedure ](1)};

 

We tried to use Exdesc like P1="test_parameter" but get this warning:

"Warning, Point - a : recognized as a GROUP_MEMBER tag.W"

 

The we tried to relace 1 with ? in the call, but get this warning:

"Warning, Point - a : bindParam () : [S] [42000]: [Microsoft][ODBC SQL Server Driver][SQL Server]The database name component of the object qualifier must be the name of the current database."

 

Does anyone have an idea, how to solve this?

 

Best regards and thank you!
Mathias

Outcomes