>I am having a problem getting decimal values from a stored procedure. The SQL stored procedure works correctly in SQL Query Analyzer and prints a value of say 17.25.
>
>When I use the following in VB.NET the answer (param.value) returns 17D with no decimals.
>
Just a WAG, but try specifying the type when you create the output parameter:
Dim param2 As IDbDataParameter = Me.CreateParameter("@ItemSum", 0, DbType.Decimal)