SQL Server varbinary(max) field and clarion dictionary

[MikeR]

I know this is the wrong forum but....
maybe someone can point me in the right direction.
I need to read/write to a sql table that has varbinary(max) field type.
I cant seem to define the dictionary properly.
clarion imports the table field as a string (1)
I thought a blob field would work ?
The clarion database driver manual says blobs are supported in sql, obviously im doing something wrong

[peterH]

Blob should work fine. But remember to tick Binary in the dict.

Peter

[MikeR]

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 ?

[osquiabro]

try to install the correct sqlclient for sql version and force yours app to use driver in clarion:

DRIVER={SQL Server Native Client 11.0}

[MikeR]

Thanks osqulabro
I am using sqlexpress
where do I look for or put
DRIVER=(SQL Server Native Client 11.0)

sorry for my ignorance ?

[osquiabro]

in your connection string