Execute "set scan off" from vb 6.0 adodb connection
713788Jul 28 2009 — edited Jul 29 2009Hi,
We are trying to execute "set scan off" from vb - but it throws an error like missing or invalid option.
We also tried clubbing two statements like - "set scan off;insert into table_name values...;" but still the errr is same,
We are using adodb connection object's execute method.Rest all ddl and dml are working fine. Any help appreciated.