Operand type clash: IMAGE is incompatible with TEXT

[Biju Sam]

Hi, Sincere request to give a solution to my problem. I will explain in detail. I have an application in ASP.Net, Sybase which was running very fine in windows 2000 server. Recently i migrated it to a windows 2003/IIS6.0 server. After the migration one of the pages is having an error I'm trying to insert a byte[] data to sybase with Column datatype TEXT. I get this error: Sybase.Data.AseClient.AseException: Operand type clash: IMAGE is incompatible with TEXT This is the function which does this. public static bool Archive(string ReportID, string ReportDate, string User, DataTable ReportDataTable, string ProfileRegionID) { ArrayList ar = Report.ConvertToArrayList(ReportDataTable); AseParameter[] myParams = new AseParameter[1]; AseParameter p = new AseParameter(); p.ParameterName = "@report"; p.AseDbType = AseDbType.Text; byte[] ReportData = DB.Data.Adaptors.XML.ConvertToXMLStream(ar).ToArray(); p.Size =ReportData.Length; p.Value = ReportData; myParams[0] = p; Adaptor a = new Adaptor(); a.ExecuteStatement(@"insert into ReportHistory (report_id,report_date,report_data,create_user,create_date,profile_region_id,locked,version) " + @" values(" + ReportID + ","+ReportDate+",@report,'"+ User +"','" + System.DateTime.Now.ToShortDateString() + "',"+ProfileRegionID+",0,0)" ,myParams, CommandType.Text); a.Dispose(); return true; } In this function when the query executes an error saying Sybase.Data.AseClient.AseException: Operand type clash: IMAGE is incompatible with TEXT is coming . Please help. Thanks in advance. Biju S