ADODB

I hate microsoft. I spent 3 hours this morning trying to figure out why a stored procedure would not execute, and kept blaming one of the parameters as being OUTPUT when it should be INPUT. And it was the wrong one. I finally noticed that my code all uses adoCmd.namedParameters = true, and Dmitriy's didn't. I set it, and it worked. Grrrr... I was ready to throttle someone over that. I mean, ADO could have said, "Hey, this is SQL Server, he's giving me @Names for the procedures, I'll bet he's using named sprocs!". But nooo. Way too much stress over this.