>I see,so when ever the COM executes an SQL. I should send the SET ENGINEBEHAVIOR statment before I send the SQL command. Correct?

As long as ADO connection is open it'll remember the settings. If connection is open every time than you'll have to set SET ENGINEBEHAVIOR every time.