>>I tried the cast, as you suggested. And it works with the varchar(max) and the Native Client. Here is how I did it:
>>

>>select (cast myvarchar as text) as myvarchar from my table
>>

>>And it works! This is TONs of work for me to go through all reports and instead of getting the varchar(max) directly, change it to CAST as Text. But at least there is a solution.
>
>GoFish may be able to help you. I've found its Replace mechanism to be very reliable and you can write custom code to the replacement, if a straightforward replacement won't work for you. Check my article: http://www.tomorrowssolutionsllc.com/Articles/Do%20custom%20replacements%20with%20GoFish.pdf
>
>Tamar

I do use GoFish a lot. But for this case, I don't think it will be applicable. First, I will have to test my approach on my own PC, then on a couple of customers, and then start implementing it on all reports. I am guessing I have about 200 reports in the application. The goal is to make the application be ready for using old (SQL Server) or newer (SQL Server Native Client 11.0) drivers.

Thank you.