>>>Boris,
>>>
>>>The statement I posted was from the profiler. As you see, the @p1 parameter was passed as '' instead of the value.
>>>
>>>My question is - where is the link for the driver for Windows XP. I found ODBC 11 driver but it doesn't list Windows XP as supported platform.
>>
>>There is no driver for XP.
>>It is not supported.
>>Maybe you could try to install SQL native Client for SQL Server 2008 or 2008?
>
>I think the SQL Server native client has problems with varchar(max) column. Also, can you give a link to that he needs to install?
>
>I'll check the version of his database.
>
>BTW, he told me that it works fine on that same machine with a different database. So, it could be database properties... I'll check compatibility level of DB with him next.
Strange,
I never had problems with Native client.
https://msdn.microsoft.com/en-us/data/ff658533.aspxhttp://www.microsoft.com/en-us/download/details.aspx?id=17943
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.