Retrieval of Text (SQL_LONGVARCHAR) type of column

[Pradip shah]

Hello,
I am attempting to retrieve the text (SQL_LONGVARCHAR) type of column
from the database (SQL SERVER). The online help suggests to use 'dbreadtext'
API to
read text or image values. My text column length is about 37000 bytes.
I am also using dbsetopt to set the DBTEXTSIZE and DBTEXTLIMIT (each is
set to 4 million bytes). I am calling the 'dbreadtext' succesively until
I reach to the end of the row (getting the chunks of the same text value....
each chunk being 500 bytes). Somehow, I am getting only 4096 bytes which
I understand is a default value of the TEXTSIZE. This is surprising as
I am setting TEXTSIZE to a much higher value. I understand the network
packet size is 4096 bytes. I am using MS SQL SERVER Client 6.5; the
platform is WIN NT and the application programming is done in MS Visual
C/C++. Has anyone encountered this problem? The MSDN says that, for each
text value, all that is stored in the data row is a 16-byte pointer. Do
I need to do something about this? Any pointer will be greatly appreciated.

Thanks,
Pradip Shah
pradip.shah@ca.com