long text not displayed

hello,

I have problem and i really don't know what is wrong. someone gave me een DB (.bak) and i restored it in MS SQL Server. Everything looked normal. In the DB, there is a table with a column ntext(16) and some other columns (id,...). When i look in the Enterprise manager i see <long text> in the column ntext. What is normal i think. But when i try to display (ASP - select * from) the table in the browser everything is reproduced well, except the column with the long text. It seems to be empty! (also in the source code). But when i do a search on a word in the text (where text like '%word%'), there are displayed some records!! so it can't be empty, no?? here also, i see everything of the records, except the long text.

can anyone help me?

This is an ASP problem, not a SQL server problem. Are you sure you have the latest SQL client drivers on the webserver. Perhaps you can try casting that column as varchar in the SQL select statement and see if something shows up.

euhmm, i don't know. I only downloaded the SQL Server trial software. What do i have to download besides that?




can you give me a little hint how to do that?

barbara