Re: Problems with ntext, nvarchar

From: Steve Kass (skass_at_drew.edu)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 14:45:37 -0500

Lynn,

  There is a news post from a couple of years ago suggesting that you
might solve this problem by setting CursorLocation property of your
connection to 3. You'll find the post here:
http://groups.google.com/groups?q=wzmh+byadding

SK

Lynn wrote:

>Hi there,
>I am having problems in my ASP code (ADO) getting any data of type
>ntext or nvarchar from the database. It just appears blank. Having
>done some research I found that you must retrieve the ntext, nvarchar
>types of data at the end of the SELECT statement and then all is well.
>I did this and it works fine. However I need to resolve this problem
>properly.
>
>Is there any patch which gets around this problem? I am running SQL
>SERVER 2000 and I find it hard to imagine its not already fixed.
>
>Thanks in advance,
>Lynn
>
>