Re: Text field

keeping the text field as the last column in the select statement and
Setting the prop did the trick.

    bool bStream = true;
    CDBPropSet  dbProp(DBPROPSET_ROWSET);
    dbProp.AddProperty(DBPROP_ISequentialStream, bStream);

thanks,
Badre


-----Original Message-----
From: BadreNarayanan V [mailto:[email protected]]
Sent: Monday, October 28, 2002 4:31 PM
To: [email protected]
Subject: [OLEDB_DEV] Text field


I am trying to access the datatype 'ANSI_SQL_LONG_VARCHAR' using ATL 7.0
Oledb consumers, I am using the MSDASQL provider I need to access the field
from both MSSQL-2000 and Oracle database.

When i debug, the call to BindColumns(){ GetRowsetProperties}(from
atldbcli.h) returns DB_S_ERRORSOCCURED and I see the ATLTRACE message
"neither ISequentialStream nor IStream are supported!"

Do i need to set some prop before opening the rowset? do i need to handle
differently?

any help is appreciated.

thanks,
Badre

You can read messages from the OLEDB_DEV archive, unsubscribe from
OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.