Executing stored procedure from vba

[davetek]

hi,

i am trying to execute a stored procedure from excel(vba)...this works fine when i pass one parameter. however when i pass the second to the SP it does not work.


Cmd.ActiveConnection = cnt
Cmd.CommandType = adCmdStoredProc
Cmd.CommandText = "SP_CreateTest"
Cmd.Parameters.Append Cmd.CreateParameter("", adChar, sDate)
'Works up to this point
'but when i add the line below i get an error
Cmd.Parameters.Append Cmd.CreateParameter("", adChar, sName)

Cmd.Execute


any ideas???

 

[cmmrfrds]

Paste in the code of you SP up through the parameter definitions.

 

[davetek]

Sorry, I don't understand what you mean?

 

[cmmrfrds]

This part shows the parameters.

CREATE PROCEDURE au_info2
@lastname varchar(30) = 'D%',
@firstname varchar(18) = '%'
AS