>>>>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=17943Right 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.
If it's not broken, fix it until it is.
My Blog