I am getting the exact same error. I have a huge binary file and I want to pass the binary content (as is) from Visual FoxPro to SQL Server using insert command or update command. I am getting this error. Is there a way to bypass this error?

My SQL command looks like this

insert into Settings (SettingVal) values (cast (long binary string here as varbinary(max)) -- tried using image with the same result.

May be I should try adding single quotes around the varbinary value?