I ran the ODBC reinstall when I first started looking into the problem. I have just checked the driver version on this machine and on the server and they are both the same so I presume they are the versions shipped with this version of Sage (14.01.21.241).
The ODBC version is given as...
Gemma - I've tried linking with ODBC both by selecting the primary key in the Sage Table and then again by not selecting any field in the Sage table. I have experimented with obvious text fields using both <> and NOT LIKE and I have tried using apparently numeric fields again with <> and NOT...
This thread is running again on the Sageforum site but it still doesn't address the issue of why some people have no problem using the <> and NOT LIKE operators whilst other people do. There are various ways of working round the problem and thank you Johno for your contribution but it still...