ASA Stored Procedures

[Jamie_Irwin]

When I try to call a Stored Procedure in ASA from VB 6 I get "Syntax error
or access violation: Wrong number of parameters to function
'qsSelectOrgsForUserId'"

The Stored Procedure has only one input parameter @UserId and I have tested
it from Interactive SQL. I am using a demo version of ASA 7.

I have also had success call Stored Procedures that have no parameters.

My vb code is:

With cmd
Set .ActiveConnection = gMSDEConnection
.CommandText = "qsSelectOrgsForUserId"
.Parameters.Append .CreateParameter("@UserId", adVarChar,
adParamInput, 10, gCurrentUser.UserName)
Set rs = .Execute(, , adCmdStoredProc)

Any help would be apprecieted.

Thanks,

Jamie Irwin
Jamie...@MetsysSolutions.com

[Jason Hinsperger]

Is the parameter declared as IN, OUT or INOUT?
I would suggest declaring it as INOUT

--
Jason Hinsperger
International and Sustaining Engineering
Adaptive Server Anywhere