Field Type Problem

Could you post exact error message here? It's not clear what exactly causes the trouble.

Exact error:
"Microsoft OLE DB Provider for SQL Server error '80040e14'

The data types text and nvarchar are incompatible in the equal to operator.

/P51/include/aspfunctions.asp, line 1242"
It is the 'Description" field I was talking about. When I remove it, no more errors. But I cannot change that field type.

Post lines 1230-1250 from include/aspfunctions.asp file here pointing which line is 1242. We'll add some debug info to find what exactly is happening.
What strange is that this is happening on print page only.

Here is the output
end function
function db_exec(sSQL,conn)

if IsIdentical(dDebug,true) then response.write sSQL & "
"

conn.Execute sSQL

call ReportError

end function
function db_query(sSQL,conn)

dim asp_rs

if IsIdentical(dDebug,true) then response.write sSQL & "
"

Set asp_rs = server.CreateObject("ADODB.Recordset")

1242 asp_rs.Open sSQL,conn

call ReportError

set db_query=asp_rs

end function
function db_query_direct(sSQL,conn,a)

set db_query_direct=db_query(sSQL,conn)

end function
function db_fetch_array(asp_rs)

Try to add the following line

right before

Post here SQL queries from the page that breaks.

Just to clarify - the error pertains to a field in the table view that is derived from a different mssql database (which I cannot modify). The field type is text. I've found a workaround - if i create field alias in print page I can change the field type and everything works.