Wednesday, January 20, 2010

Problem with varchar(max) via SQL Native Client

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

No comments: