I'm running an insert statement using OLE DB and an ICommandWithParameters.

In the ICommandText, I made sure to set:

params.cParamSets = n ;

Then

cmdTxt->Execute( NULL, IID_NULL, ¶ms, &rowsAffected, NULL ) ;

Where n > 1, but in my database, all I see is 1 insert happening.

The docs say cParamSets is greater than one) can be specified only if DBPROP_MULTIPLEPARAMSETS is VARIANT_TRUE and the command does not return any rowsets.

But I set DBPROP_MULTIPLEPARAMSETS in my DBPROPs, and its and INSERT statement so it should not return any rowsets.