Can you post your code?
I think your problem is just a syntax error versus a problem with ADO.NET.
>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?
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi