«

I'm trying to execute a datareader that calls a SQL Server stored procedure
and I get this error. I also tried loading a dataset using the database
adapter Fill method and I get the same error.

I have other ASPNET applications that do these things without a problem.

Anyone have any suggestions?

For the thread...if anyone's interested.

I resolved this problem. I was passing a parameter to my stored procedure.
I was incorrectly assigning the value to a "varchar" parameter.

Incorrect:

SqlCommandObject.Parameters("@Param").Value = txtTextBox

Correct:

SqlCommandObject.Parameters("@Param").Value = txtTextBox.Text

When it attempted to execute the datareader or the Fill method, SQL Server
(or was it ADONET) was attempting to convert a text box object to a varchar
instead of a text string object to a varchar.

An example of ambiguous naming conventions biting me in the ...


"Bob Frasca" <> wrote in message
news:%...
> I'm trying to execute a datareader that calls a SQL Server stored
procedure
> and I get this error. I also tried loading a dataset using the database
> adapter Fill method and I get the same error.
>
> I have other ASPNET applications that do these things without a problem.
>
> Anyone have any suggestions?
>
>