I have a stored procedure which selects data from couple of tables and insert it into a temp table. How can I call this stored procedure from ASP?
recordset.open "exec SpName " & parameter1 & "," .....<BR>Or<BR>Use a command object <BR>OR<BR>Just execute with the connecion object<BR><BR>
I did that but getting this error.<BR><BR>"The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. "<BR><BR>I can't figure out what does that mean.
That is an ADO error....has nothing to do with the SP<BR><BR>ensure the connection object is created and open.