NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: MikeR on August 07, 2016, 05:35:45 PM

Title: SQL Server varbinary(max) field and clarion dictionary
Post by: MikeR on August 07, 2016, 05:35:45 PM

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 ???

Title: Re: SQL Server varbinary(max) field and clarion dictionary
Post by: peterH on August 07, 2016, 08:41:33 PM

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

Peter

Title: Re: SQL Server varbinary(max) field and clarion dictionary
Post by: MikeR on August 08, 2016, 10:36:21 AM

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 ?

Title: Re: SQL Server varbinary(max) field and clarion dictionary
Post by: osquiabro on August 09, 2016, 03:59:39 AM

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}

Title: Re: SQL Server varbinary(max) field and clarion dictionary
Post by: MikeR on August 10, 2016, 03:25:28 AM

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

sorry for my ignorance ?

Title: Re: SQL Server varbinary(max) field and clarion dictionary
Post by: osquiabro on August 10, 2016, 04:09:40 AM

in your connection string