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