on 11-30-2020 9:53 AM
Dear all,
in the SBO_SP_TransactionNotification, updating an item master data, I need to execute a check via PL-SQL select statement to a remote db server via Linked Server.
I use the following command:
EXEC sp_executesql @dynamicsql, N'@ResultCountOut INT OUT', @ResultCountOut=@ResultCount OUT
but I have the following error:
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server
"REMOTE_SAP_CENTRAL" was unable to begin a distributed transaction. 'Company Info' (CINF) (CINF)
I already tried to enable "allow inbound" and "allow outbound" in the MSDTC Windows Service
and to use the SELECT ... FROM OPENQUERY(<linked server>, @sqlstatement) ...
but the issue is not solved.
Please, can someone give me a solution to execute a remote query into the SBO_SP_TransactionNotification?
Best Regards
Emanuele
Solved activating the "allow inbound" and "allow outbound" option in the MS DTC component service settings on both sql server machines (source and destination).
Best Regards
Emanuele
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.