Calling stored procedure from ASP page!

[z07924]

set cn = server.CreateObject("ADODB.Connection&quot
set cmd = server.CreateObject("ADODB.Command&quot


cn.Open Application("Connection&quot
set cmd.ActiveConnection = cn

cmd.CommandType = adCmdStoredProc
cmd.CommandText = "Sp_ContactList"
cmd.Parameters.Refresh


cmd.Parameters(1) = Session("LoginID&quot
cmd.Parameters(2) = strContactName
cmd.Parameters(3) = strContactEmail

cmd.Execute lngRows, , adExecuteNoRecords

lngRetValue = cmd.Parameters(0)

'error handling......

if isempty(lngRetValue) or lngRetValue <> 0 then 'errors occured
if isObject(cn.Errors) and cn.Errors.Count > 0 then ' errors from db server
strErrMsg = cn.Errors(cn.Errors.Count - 1).Description
else ' other errors
strErrMsg = Err.Description
end if
end if




Getting error in the below line.
cmd.CommandType = adCmdStoredProc

the error is given below,

Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/HitDev/SaveDetails.asp, line 51

Could u please let me know, what kind of error is this?...

I have no idea. I am just calling a stord procedure from the asp page passing 3 parameters.

Thanks,
laks

 

[TonyU]

Here's one description of the error:

http://aspfaq.com/show.asp?id=2102

[sup]

There's never time to do it right, but there's always time to do it over!
[/sup]

 

[lebisol]

-read through this for some samples etc.:

http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1

perhaps it can help clear out the miss_under_standings
all the best!

 

[TootingBoy]

Try checking the length of the values you are using to populate the Command Object parameters. This error can occur if they are longer than the length specified in the Stored Procedure definition itself.

I myself have been caught out by this problem in the past when a particularly long email address was passed to a Stored Procedure parameter.

The path to freedom is seldom trodden by the multitude.