>>>>>I never tried with XP, only Win7.
>>>>>
>>>>Windows 7 and SQL Server Driver works fine for me for varchar(max) columns. It is the SQL Server Native client that has problem.
>>>
>>>Do you know the version number for the driver?
>>
>>In my case it's Microsoft SQL Server ODBC Driver Version 06.01.7601, in his it's 03.85. I see the driver version on the last page when configuring DSN.
>
>I don't use DSN, but I don't know if that's relevant or not. If my memory serves me right, you will get problems with other field types with the driver that supports Varchar(max).

Right, as we just discussed with Hugo the date and time types do not work. I guess filestream will not work either. Need to refresh my memory on other new types. In any case, in our database we're only using varchar(max) and varbinary(max) and these two types, I believe, work with that driver.

Link to new data types in SQL 2008 (just to refresh my memory):

https://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-the-new-data-types/

BTW, that link doesn't talk about XML data type and I believe it was added in SQL 2008 as well.

All types

https://msdn.microsoft.com/en-us/library/ms187752.aspx?f=255&MSPPError=-2147217396 for 2014