Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Native Client issue with varchar(max) Expand / Collapse
Author
Message
Posted Wednesday, August 13, 2008 1:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 54, Visits: 307
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
Posted Wednesday, August 13, 2008 6:56 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:39 AM
Points: 338, Visits: 3,289
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.
Post #551842
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse