Error Messages

This part gathers some of the most common error messages you may run into.

1. "Index was out of range" when trying to set a parameter's value: you probably had a typo in the parameter name. Basic4ppc could not find a parameter added by that name.

2."Insufficient parameters supplied to the command" message when executing one of the execute subs. Most probably you did not set value to one of the parameters specified in the SQL statement. You may have forgotten to add them at all. You may have a spelling mistake.

3. DataReader already active on this command: you did not use the DataReader.Close Sub before trying to execute another command.