ODBC + CRecordset

I'm using sql serser 2000, CRecordset, CDatabase, ODBC, VS.NET 03, VC++

How cat I get from my data base ntext or nvarchar value?

if I get varchar everything is ok, but not nvarchar..(or text field type).

I need help please with this.

maybe the solusion is to cast from ntext to text?

How can I casting this in my statment?

// activity as ntext (16)

SqlString = "SELECT activity FROM tasks WHERE status_id=1";

Yael.

What is the code which works for you in the case of varchar? And what doesn't work exactly with nvarchar?

Please provide an excerpt and perhaps we could find a solution.

Thanks,