>>>>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.aspx
>http://www.microsoft.com/en-us/download/details.aspx?id=17943

Right after our meeting I'll try to get a hold of him and look at the things again. We will also try to use Native client for our DSN.