Problem in calling Procedure from ASP program

[rskshiva]

Hi,

I had written a code to call a stored procedure as follows.

-------------------------------------------------------
dim cmdDelivery, objparameter
set cmdDelivery = server.CreateObject("ADODB.Command")
cmdDelivery.ActiveConnection=conn
cmdDelivery.CommandText = "OT_SP_GetDeliveryDetailsForOrder"
cmdDelivery.CommandType = adCmdStoredProc
set objparameter = cmdDelivery.CreateParameter("@Order_No",adBigInt,adParamInput,,Cint(orderNo))
cmdDelivery.Parameters.Append objparameter
cmdDelivery.Execute
set cmdDelivery = nothing
-------------------------------------------------------


Stored procedure is as below
-------------------------------------------------------
CREATE PROCEDURE OT_SP_GetDeliveryDetailsForOrder ( @Order_No As BigInt ) As

----- Code here

GO
-------------------------------------------------------

But the ASP page displays the following Error.

ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.


Kindly suggest me.

Note: Procedure is running from Query Analyser

Regards,
Siva Kumar R

[russell_g_1]

an empty connection string maybe?