Parameter ?_1 has no default value

[kiln]

I'm using the HierCube .net OLAP component from rainbowsoft
(http://www.rbwsoft.com/) in a vb winform application (vs2003). The data
source is an MS Access 2000 table; the data adapter is of the oledb
type; and the sql string has two parameters ala =?

At runtime the app provides values for the params like so:

oledaPivotData.SelectCommand.Parameters("Conversion").Value =
cboConversion.SelectedValue
oledaPivotData.SelectCommand.Parameters("Year").Value =
cboYear.SelectedValue

The cube works fine. However the cube control won't let me access the
Dimension Mapping facility, it complains that "Parameter ?_1 has no
default value". I'm not sure how to solve this. I've written to the
control developers, but they can be slow to respond...and this issue
seems to be more generic than specific to this control. I've not been
able to find a discussion here that deals with my situation, most other
cases are using SPs.

 

[kiln]

Right after posting this I found the manner in which param default
values are set, via the params collection in properties. That solved it.