Recordset won't execute

[llaurit]

I created a connection in vbScript to a SQL database. I set parameters to update the table. I used these settings:
objCmd.CommandText = sp_name
objCmd.CommandType = adCmdStoredProc

When I use "cmdObj.execute," I get the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E30)
Parameter type is not supported.


I also tried "Set recordsetObj = cmdObj.execute" and I get the following error:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.

 

[crystalized]

If your stored procedure has parameters, I think the parameter values must come after the execute like this

obj.execute param1,param2.........

although I am not positive of this. Probably if you look in the help or through old posts on the asp forum you might find more info.
Crystal
crystalized_s@yahoo.com

--------------------------------------------------

Experience is one thing you can't get for nothing.

-Oscar Wilde

 

[llaurit]

Thank you for the tip, but I ended up switching my method for adding the data.

Lynn