SQL Native Client issue with varchar(max)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL Native Client issue with varchar(max)

SQL Native Client issue with varchar(max)

Rate Topic

Display Mode

Topic Options

Author

Message

virgo

Posted Wednesday, August 13, 2008 1:07 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 3:54 AM
Points: 51, Visits: 185

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

Post #551638

andrew gothard

Posted Wednesday, August 13, 2008 6:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:41 AM
Points: 146, Visits: 1,637

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

A backup strategy is worthless. A tested and documented *recovery* strategy though ... now you're starting to get somewhere.

Post #551842

« Prev Topic | Next Topic »

Permissions