Having issue with retrieve data from varchar(max) field. This is turned out a problem with SQL Native Client. Tried to use “SQL Server Native Client 10.0”, with same result.
Than I have to revert back to use “SQL Server” driver, which doesn’t has performance as good as SQL Native Client driver.
Hope Microsoft will fix it some day.
Here is the link of bug reported: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=467300&wa=wsignin1.0