must set .Size property for output SQLParameter

  • Thread starter Thread starter John A Grandy
  • Start date Start date
J

John A Grandy

for ADO.NET SQLParameters with SQLParmaeter.Direction =
ParmeterDirection.Output ....

apparently , contrary to the documentation , you DO have to set the
SQLParameter.Size property ...

or you get errors like this :

Message "Parameter 1: '@EntityTypeName' of type: String, the property Size
has an invalid size: 0" String
 
I have found the same problem. Without the size it does not work. You need to
post the size of the output parameter or you will get the size error returned.

cheers
Hawk
 
Back
Top