Hi,
I was using the following select statement on access database it was working fine. Now i am using MSDE, now i am geting following error

str= "select count(*) from messages where sender_id='" & id & "'"
Set rsEvents1 = server.CreateObject("ADODB.Recordset")
rsEvents1.Open str, Conn


Microsoft OLE DB Provider for SQL Server (0x80040E14)
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
/ambdex/login_check.asp, line 119