Odd error calling SQLCommand.ExecuteReader() from powershell

Question

What does Powershell error below mean when you are calling SqlCommand.ExecuteReader()?

System.Management.Automation.ValidationMetadataException: The argument "+" does not belong to the set "unicode,utf7,utf8,utf32,ascii,bigendianunicode,default,oem" specified by the ValidateSet attribute. Supply an argument that is in the set and then try the command again. at System.Management.Automation.ValidateSetAttribute.ValidateElement(Object element) at System.Management.Automation.ValidateEnumeratedArgumentsAttribute.Validate(Object arguments, EngineIntrinsics engineIntrinsics) at System.Management.Automation.ParameterBinderBase.BindParameter(CommandParameterInternal parameter, CompiledCommandParameter parameterMetadata, ParameterBindingFlags flags)

(answer to follow immediately; I just wanted to share my debugging experience because I couldn't find it)

Dylan Brams · Accepted Answer · 2013-03-28 22:55:41Z

2

The text of the query included a 'GO' statement. There's some sort of security filtering going on, and it is considered an encoding issue.

Just an FYI for me or the universe if that kinda thing happens again. Four hours of my life I wish I'd been able to Google away.

answered Mar 28, 2013 at 22:55

Dylan Brams

2,1091 gold badge20 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Odd error calling SQLCommand.ExecuteReader() from powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related