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

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
------------------------------