I need to execute a parametrized stored procedure on MS SQL Server, that does not pull data.
It is a write-to-log in fact.
(stored procedure works fine when launched from SQL Management Studio)
Tried to open a dummy workfile but won't work
Code: Select all
wfopen(wf=xxx,page=d,type=odbc,timeout=120) Description=DEV_STG;DRIVER=ODBC Driver 13 for SQL Server;SERVER=servername;Trusted_Connection=Yes;APP=EViews;DATABASE=STG; "{call [STG].[Eviews].[log_Eviews_staging] ('"{%param1}"', '"{%param2}"')}" @keep *
wfclose xxx
Error message:
ODBC Error unable to connect to driver: in "WFOPEN
(WF=XXX,PAGE=D,TYPE=ODBC,TIMEOUT=120)
DESCRIPTION=DEV_STG;DRIVER=ODBC DRIVER 13 FOR SQL
SERVER;SERVER=CHTSGVA-DB83,1435;TRUSTED_CONNECTI
ON=YES;APP=EVIEWS;DATABASE=STG; "{CALL
[STG].[EVIEWS].[LOG_EVIEWS_STAGING] ('"CHL"',
'"CHILE"')}" @KEEP *".
Bizarrely, the same driver works few lines before on the wfsave command
Any ideas?