I'm having trouble bringing over data of type "nText" from SQL Server using SQL pass through. There have been a number of documented issues, some of which I've found in UT and others which I found at MSDN, but I haven't found much in the way of solutions, and I'm wondering if someone could help.

The main issues is that the nText fields of the cursors created through SQLExec are converted to char fields of size 255. The same issue occurs when using a remote view, even if I set the property "usememosize". This behavior is documented on MSDN.

I have seen one solution on UT where it was suggested that I cast the nText data type to text. So I'll execute the following SQL:

select cast(title as text) from booktitles

The resultant cursor is not browsable - I get the following error:
"No update tables are specified. Use the tables property of the cursor."

Casting would be a fine solution, but I can't get around the above problem.

If anyone has any ideas on how to solve my problem - either to view the casted fields or to get around the nText problem, I would appreciate your help.

Thanks,

David