Thanks Peter I changed it to Blob with binary on and it now works with only small files.
I get this error on larger files:
The text, ntext, or image pointer value conflicts with the column name specified
I got this from the web:
Cause Prior to Service Pack 2, Connect for ODBC 6.0 used the 2005 revision of the TDS protocol, which did not directly support the VAR...(MAX) objects. Such types would be converted to LONG types, which failed beyond a certain size.
Resolution Support for TDS 2008, including support for the VAR...(MAX) types, was added in Connect for ODBC 6.0 SP2, which can be obtained by applying the latest patch.
But Im not using odbc Im using clarion sql server driver ?