clear sql stored proc param list (1 Viewer)

[spinkung]

hi

i am calling a stored proc and passing some params (sql). i need to loop through the execute a few times though before i kill the connection.

i getting an error saying there are too many params on the second run through. What i need is to clear the param list once it's executed once.

is this possible or to i need to keep killing the conn then re-connecting to the db?

thanks

 

[namliam]

what code are you using??? ado?dao?please post your code cause the problem will be in your code/loop not in the connection/sp (most likely)