I am new to OLE DB. I am trying to run a Stored Proc on a Microsoft SQL database from VC++ 6.0 SP5. I am creating the the data source, the session, and the command text. Then I call SetCommandText with DBGUID_DEFAULT and DBGUID_SQL as the first param and "Call the_stored_proc()" as the second command. The stored proc does not take any parameters. Then when I call Execute, it fails with a 0x80040e14.

My best guess is that I need to set some type of property with the ICommandProperties object that I can aquire from the command object.

Am I correct? If so, what property do I need to set? Currently I am not setting any.

Sam