Post reply

SQL Native Client issue with varchar(max)

  • August 13, 2008 at 1:07 am

    #191230

    Hi all,

    In my application is using "SQL Native Client 2005.90.1399.00" odbc driver and if i tryto update a field

    of 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 advance

  • August 13, 2008 at 6:56 am

    #857368

    It'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.aspx

    This gives advice on how to get your app to stream directly rather than buffer the results

    hth

    Andrew

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply