Arguments are of the wrong type, are out of acceptable range, or a

Arguments are of the wrong type, are out of acceptable range, or a

Post by TGluZGEgTG » Sat, 20 May 2006 00:45:02


Can someone tell me what I can change here to fix this: Arguments are of the
wrong type, are out of acceptable range, or are in conflict with one another.
???

This is the code that generates it (The last Line):

<!--#include file="Ado1v.inc"-->
<%
'*********open the onhold Table and set the space being looked at in there
if it is not already in there

Dim RST, VarSQL, ObjConn, cmdHold

set ObjConn=Server.CreateObject("ADODB.Connection")
objConn.Open
"Provider=SQLOLEDB;Server=XX.XXX.XX.XX;Database=XXX;UID=XXX;PWD=XXX"
set cmdHold=Server.CreateObject("ADODB.Command")
set rst = Server.CreateObject("ADODB.Recordset")
cmdHold.ActiveConnection=ObjConn
'response.write(cmdHold.ActiveConnection)
cmdHold.CommandType = adCmdStoredProc
cmdHold.CommandText = "CheckForHolds"
cmdHold("@TreeIn") = TreeIn
cmdHold("@XIn") = XIn
cmdHold("@YIn") = YIn
cmdHold("@SessionIn") = Session.sessionID

rst.Open cmdHold.Execute,cmdHold.ActiveConnection,adOpenDynamic,
adLockOptimistic
%>