proc sql update error ERROR: Open cursor error: ICommand::Execute failed

[havmaage]

When i try to update a table in MSSQL through SAS like this 

proc sql;
update sandtab.opret_sqltabel_fra_sas
set Simon = 1
where Simon = 0;
quit;
run;

It errors out with 

ERROR: Open cursor error: ICommand::Execute failed. : The requested properties cannot be supported.

its only seems to be updating that fails, following statement works fine on the same table 

proc sql;
insert into sandtab.opret_sqltabel_fra_sas ( col1,col2, col3, col4,Simon)
values (99, "Simons kontoform", "N", '2019-05-13 09:48:05.033'dt,11);
quit;
run;

The datatype for column Simon in my SQL table is float. 

[ChrisNZ]

What happens if you run

proc sql;
  connect using SANDTAB;
  execute by SANDTAB (
    update opret_sqltabel_fra_sas
    set Simon = 1
    where Simon = 0
  );
quit;

[havmaage]

Thanks for your reply, 

I dont work unfortunately. 

16 proc sql;
17 connect using sandtab;
ERROR: SERVER= option, required for connection, not found.
18 execute by sandtab (
19 update opret_sqltabel_fra_sas
20 set Simon = 1
21 where Simon = 0
22 );

ERROR: The SANDTAB engine cannot be found.
ERROR: A Connection to the sandtab DBMS is not currently supported, or is not installed at your site.
23 quit;

[ChrisNZ · Accepted solution]

You seem to not have declared your library.

[havmaage]

Actually ít just got to works this moment, haven't 

assigned my libname through the server and not directly 

like this 

libname Sandtab slibref=Sandtab server=saspi;

And then it worked ok. 

Thanks for your input. 

[ChrisNZ]

That's a remote libnane. You never mentioned you were using a server. Glad it works anyway.

[havmaage]

Sorry about that, i am a not that familiar with the SAS Environment but my learning curve is
steep. Have good day