>I'm getting
>
>OLE IDispatch exception code 0 from Microsoft OLE DB Provider for SQL Server: Invalid character value for cast specification...
>
>I have looked at all the fields they all seem to be normal. What else can I look for? What would cause this error?

Are you getting this error on SELECT or UPDATE/INSERT command? In any case, can you post it?

Thanks.