If anybody knows, what does that error message means, please, tell.
I run vb program, which use a Command object to run a SP and I am getting an error message:
"Invalid character for cast specification"
:p
Printable View
If anybody knows, what does that error message means, please, tell.
I run vb program, which use a Command object to run a SP and I am getting an error message:
"Invalid character for cast specification"
:p
what's the SQL?
This may be of interest http://support.microsoft.com/support...SRCH&SPR=MSALL
It's difficult to say specifically what's causing your error from
what info you've supplied, but you can safely assume either
an input or output parameter to your SP is defined as the
incorrect datatype.
Also, FWIW, in SQLServer v7 without SP2 installed, a negative
zero (-0) result will cause this error.
Its a syntax problem. Try placing quotes around your variable
Regards....
Gaz