Hi Marko
Try including your stored procedure in the connection, for example:
ODBCConnection conn("DRIVER=[driver here];SERVER=[server here];Trusted_Connection=Yes;DATABASE=[db here];","exec [sql_procedure here]");
Best regards,
Cesar
------------------------------
Cesar Guzman
------------------------------
Original Message:
Sent: Wed April 28, 2021 03:57 PM
From: Marko BLAIS
Subject: DBExecute statement in OPL 20.1
Hi,
In OPL 20.1, you add ODBCRead to replace DBRead and ODBCPublish to replace DBUpdate.
I can't find ODBCExecute to replace DBExecute.
That said, how can I execute a store proc in SQL Server without the DBExecute ?
Thank you
------------------------------
Marko BLAIS
------------------------------
#DecisionOptimization