Im getting an error message when I try to pass parameters to an SP in SQL Server.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
[Microsoft][ODBC SQL Server Driver]Invalid scale value

The datatypes are Decimal for these columns. I have used AdDecimal and adNumeric and still get the same results.


.Parameters.Append .CreateParameter ("@SubFam_DesctoMin", adNumeric, adParamInput, 5, Request.Form("SubFam_DesctoMin"))
            .Parameters.Append .CreateParameter ("@SubFam_DesctoMin", adNumeric, adParamInput, 5, Request.Form("SubFam_DesctoMin"))

See this article for example of how to set both precision and scale for adNumeric parameter.
http://support.microsoft.com/default.aspx?kbid=188574