Hi,

I'm trying to get the NTEXT field from SQL7.0 to display on webpage with ADO, but I received the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Errors occurred

The following is my code:

<%
dim XSEL

myDSN="DSN=INVENTORY;uid=xxx;pwd=xxx"
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
form_ID=Request.QueryString("which")

sqltemp="select * from ProblemHistory where workstation_name = '"& form_ID &"'"
set rstemp=conntemp.execute(sqltemp)

USER1= rstemp("USER1")
WRKS_NAME= rstemp("WORKSTATION_NAME")
DATE1= rstemp("DATEOCCUR")
DATE2= now()
TROUBLESHOOT= rstemp("FIX_SOLUTION")
PROBLEM = rstemp("problem1")
TECH_NAME= rstemp("tech_admin")

rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%>

I was able to retrieve other field fine, except for PROBLEM field which is the ntext field in SQL.

Thanks.