You tried to set a parameter at position ‘1’ but there is/are only ‘0’ parameter(s) allowed. One reason may be that the property “ParameterNameSubstitution” is not set to TRUE in the data source.
If it were me I’d reverse the title text you have with your body text, so that when someone searches for the error message they are more likely to find the solution. This better helps others participate in your solution. If you will do that, I will upvote your question here. Also you should add an ODBC tag, and a tag for the OS you are using, and probably some information about versions of ODBC and your OS.