Asp Beginner, Need to Help

[Lethal]

Hello, I am new to ASP programming, so I would like to get some help from the rest of you guys. I can't figure out what is wrong in this page, but it's not updating my database. Anyone?? I can execute the stored proc from the query analyzer.

<%
  Option Explicit
  
  Dim objCn
  Dim objCmd
  Dim xmlDoc
  Dim xmlResponse
  Dim objPar
  Dim strXMLRequest
  Dim strConnectionString
  
  Const adCmdStoredProc = 4
  Const adParamInput = 1
  Const adVarChar = 200
  
  On Error Resume Next

  Set objCn = CreateObject("ADODB.Connection")
  Set objCmd = CreateObject("ADODB.Command")
  Set objPar = CreateObject("ADODB.Parameter")  
  
  strConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BackDate;Data Source=NETICE"
  
  objCn.Open strConnectionString
  With objCmd
	.ActiveConnection = objCn
	.CommandType = adCmdStoredProc
	.CommandText = "Add_BackDate"
  End With
  
  With objCmd
    .Parameters.Append objCmd.CreateParameter ("AssociateID", adVarChar, adParamInput, 8, "91904451")
    .Parameters.Append objCmd.CreateParameter ("AssociateLName", adVarChar, adParamInput, 40, "Yields")
    .Parameters.Append objCmd.CreateParameter ("AssociateFName", adVarChar, adParamInput, 40, "Dan")
    .Parameters.Append objCmd.CreateParameter ("OrderNumber", adVarChar, adParamInput, 9, "030263578")
    .Parameters.Append objCmd.CreateParameter ("Operator", adVarChar, adParamInput, 6, "L00m2p")
    .Execute 
  End With
  Response.Write "Done!"  
%>

[JoshT]

I don't see any obvious errors. Try this for all your params:

.Parameters.Append(.CreateParameter("AssociateID", adVarChar, adParamInput, Len("91904451"), "91904451"))

[seoptimizer2001]

I just started coding in ASP as well and had the exact same problem. In ASP, you don't need to define the CommandType like you do in VB

[JoshT]

??? But VB or ASP would both be talking to the same DLL. It works fine for me.

[seoptimizer2001]

I don't know I was kept getting an error in a page and it kept pointing to the command type and I asked another guy I worked with and he said that I didn't need that. I took it out and it worked fine. Got me.

[JoshT]

Weird. This is what I use and it works fine:

With cmd
    .CommandType = &H0004 'sproc
    '...
End With

I get the values for the constant from a copy of ADOVBS.INC I printed out and keep on my desk.

[seoptimizer2001]

Maybe it is this, it was what I was using..

With cmd
   .CommandType = adCmdStoredProc
End With

Anyways, it works without specifying the command type also.

[JoshT]

OK. I've been told that ADO works faster when you explicitly tell it stuff like that though.