WIN 2019 9.4 M7 install, uing SAS ACCESS/ODBC with proper GRANTS by Synapse DBA, yet INSERT statement failing using PROC SQL
ERROR: CLI execute error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]111214;An attempt to complete a transaction has
failed. No corresponding transaction found.
I have the sastrace tuned on, part shared
ODBC: ENTER SQLEndTran
2 <SQL_HANDLE_DBC>
0x000000006cbda3b0
1 <SQL_ROLLBACK>
ODBC: EXIT SQLEndTran with return code -1 (SQL_ERROR)
2 <SQL_HANDLE_DBC>
0x000000006cbda3b0
1 <SQL_ROLLBACK>
ERROR: CLI execute error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]111214;An attempt to complete a transaction has
failed. No corresponding transaction found.
ODBC: ENTER SQLFreeStmt
0x000000006cbdb8d0
0 <SQL_CLOSE>
TIA for any suggestion. I have also asked the DBA to share the Synpase DB GRANT setting. This particular env is using a service ID to connect and the question to DBA is for GRANT on this service ID.