Okay, so calling SP with parameters to get data is no problem. Even using SQL pass-through to get data is no problem.

Now I want to update some data. So I try to use a SP and just pass the data as parameters. I also create a SQL Update statement but I get teh same the same error message with both attempt. The error I get is system.IndexOutOfRangeException and Cannot find table 0. I drag the offending command to SQL Query Analyzer and the statement runs without a problem. I have SQL Trace on and no errors are displayed in the trace log. The SP runs to completion without any server errors. The error appears to be a VB.Net problem.

Ideas?