I need to execute a Store Procedure with VB 6. When i execute the program i receive the next message optional caracteristic is not implemented. ¿what is the problem? the execution stop in the last line.

cmdorders.ActiveConnection = MASTER
    cmdorders.CommandType = adCmdStoredProc
    cmdorders.CommandText = "SPVENTAXPERIODO"
    cmdorders.Parameters.Append cmdorders.CreateParameter("@fecha1", adDate, adParamInput, , CldInicial.Value)
    cmdorders.Parameters.Append cmdorders.CreateParameter("@fecha2", adDate, adParamInput, , CldFinal.Value)
    Set rsorders = cmdorders.Execute

What is the error message?
Assuming the stored proc returns a recordset, and that you are passing valid data in the parameters, and assuming the parameters are the correct parameters for the stored proc, and so on: then it should work, of course. But since you haven't provided the error message, how can anyone help you?

Woody Z http://www.learntoprogramnow.com

The message is "Microsoft SQL Server Driver Optional Caracteristic is not implemented.", the parameters are correct and the Sp works without problem...

That message is telling us that the Driver or Provider you are using does not support something you are trying to do.
What is your connection string?

Woody Z http://www.learntoprogramnow.com