Hi
i have an ADO command that adds a record to Database and returns an outputparameter but no records. I get errormessage 3001 and description "The application is using arguments that are of the wrong type, are out of acceptable range or are in conflict with one another". Bur how else should I use AdExecuteNoRecords. by the way, does it really to much for performance?
Please take a look at my code:

Cmd.CommandType = adCmdStoredProc + adExecuteNoRecords 'I recieve errormessage here
Cmd.CommandText = "stAddPrice"
con.ConnectionString = UDLPath
con.Open

con.BeginTrans
Cmd.ActiveConnection = con


for Each Price In colPrice

With Cmd
.Parameters.Append .CreateParameter(, adInteger, adParamInput, , Price.ID)
.Parameters.Append .CreateParameter(, adVarchar, adParamInput, 20, price.Name)
Parameters.Append .CreateParameter("Myid", adInteger, adParamInputOutput)
.Execute
End With

next

con.CommitTrans
con.Close





Thanks in advance