VB SQL error message

[yakilov]

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"

[chrisjk]

what's the SQL?

[chrisjk]

This may be of interest http://support.microsoft.com/support...SRCH&SPR=MSALL

[Mongo]

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.

[Gary Juleff]

Its a syntax problem. Try placing quotes around your variable

Regards....

Gaz