Operand Clash - TWideMemo

John Bell · Post by **John Bell** » Mon 24 Mar 2008 19:51

using a ClientDataSet with Intraweb and SQL Server. D2006 and the latest version of SDAC. if i run my app in the standalone mode from a workstation, it works. if i run my app as a dll or as an exe from the server, i get an error

"Operand type clash: varbinary is incompatible with ntext"

fixed it by changing from an ntext to a text field. thought i might have been a permission issue but run logged in as sa. it could be that something is going on depending on whether we are accessing SQL Server using TCP/IP or shared memory. the app worked when i was running version 3 of sdac. i am basically just inserting a record using insertrecord. anyway, i do not understand why this is happenig and would like to. thanks.

Antaeus · Post by **Antaeus** » Tue 25 Mar 2008 15:48

Is this problem reproduced only in projects that were migrated from SDAC 3, or even if you create a new projects? If the problem occurs only for your old projects, the the reason may be related with support for TWideMemo fields in SDAC 4. Since SDAC 4 all NTEXT fields are considered as TWideMemoField.

If the problem appears in any application, please try to reproduce it in a small VCL Forms test application, and send this application to us at sdac*crlab*com. Also specify:
- exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.