InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:04:56 GMT20http://www.sqlservercentral.com/Forums/Topic551638-146-1.aspxIt's possible that the issue is related to the fact that this version of the driver returns a default field length of zero (unlimited) for Varchar(MAX) which I think you'd have to deal with specifically in your app, from the following link http://msdn.microsoft.com/en-us/library/ms130896.aspxThis gives advice on how to get your app to stream directly rather than buffer the resultshthAndrewWed, 13 Aug 2008 06:56:48 GMTandrew gothardhttp://www.sqlservercentral.com/Forums/Topic551638-146-1.aspxHi all,In my application is using "SQL Native Client 2005.90.1399.00" odbc driver and if i tryto update a fieldof type varchar(max), am getting 'right truncation' error. If i do the same using old SQL Server 2000.85.117.00 it works fine.Any idea why this is not working with the 2005 driver?thanks in advanceWed, 13 Aug 2008 01:07:44 GMTvirgo