Click here to Skip to main content
15,926,375 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: How Find This is mail is Valid or not...! Pin
Paul Conrad25-Jan-08 3:47
professionalPaul Conrad25-Jan-08 3:47 
AnswerRe: How Find This is mail is Valid or not...! Pin
Crooze2125-Jan-08 5:21
Crooze2125-Jan-08 5:21 
AnswerRe: How Find This is mail is Valid or not...! Pin
Crooze2125-Jan-08 5:23
Crooze2125-Jan-08 5:23 
GeneralASP.NET autentication provider Pin
Yoyosch24-Jan-08 21:36
Yoyosch24-Jan-08 21:36 
GeneralRe: ASP.NET autentication provider Pin
pmarfleet25-Jan-08 11:30
pmarfleet25-Jan-08 11:30 
GeneralValidation Not working properly Pin
.NET- India 24-Jan-08 21:10
.NET- India 24-Jan-08 21:10 
QuestionHTML tag generation dynamically Pin
e.dhar24-Jan-08 20:14
e.dhar24-Jan-08 20:14 
GeneralOperand type clash: IMAGE is incompatible with TEXT Pin
Biju Sam24-Jan-08 20:09
Biju Sam24-Jan-08 20:09 
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
Questionhow to make text box lenth as static in a table Pin
Janu_M24-Jan-08 19:59
Janu_M24-Jan-08 19:59 
AnswerRe: how to make text box lenth as static in a table Pin
Crooze2125-Jan-08 5:26
Crooze2125-Jan-08 5:26 
QuestionSystem.UnauthorizedAccessException: Access to the path Denied. Pin
Biju Sam24-Jan-08 19:38
Biju Sam24-Jan-08 19:38 
GeneralRe: System.UnauthorizedAccessException: Access to the path Denied. Pin
N a v a n e e t h24-Jan-08 19:51
N a v a n e e t h24-Jan-08 19:51 
GeneralRe: System.UnauthorizedAccessException: Access to the path Denied. Pin
Biju Sam24-Jan-08 20:13
Biju Sam24-Jan-08 20:13 
Generali am using asp not asp.net Pin
Deepthy.P.M24-Jan-08 18:56
Deepthy.P.M24-Jan-08 18:56 
GeneralRe: i am using asp not asp.net Pin
Venkatesh Mookkan24-Jan-08 19:11
Venkatesh Mookkan24-Jan-08 19:11 
GeneralWrong forum Pin
pmarfleet24-Jan-08 19:41
pmarfleet24-Jan-08 19:41 
JokeRe: i am using asp not asp.net Pin
Vasudevan Deepak Kumar24-Jan-08 23:04
Vasudevan Deepak Kumar24-Jan-08 23:04 
GeneralReset dropdown using Image Button Pin
Satish - Developer24-Jan-08 18:54
Satish - Developer24-Jan-08 18:54 
GeneralRe: Reset dropdown using Image Button Pin
Venkatesh Mookkan24-Jan-08 19:22
Venkatesh Mookkan24-Jan-08 19:22 
GeneralRe: Reset dropdown using Image Button Pin
Satish - Developer24-Jan-08 20:08
Satish - Developer24-Jan-08 20:08 
GeneralRe: Reset dropdown using Image Button Pin
Venkatesh Mookkan24-Jan-08 20:45
Venkatesh Mookkan24-Jan-08 20:45 
QuestionHow to find the user name who are login currently? Pin
Sutheesh24-Jan-08 18:53
Sutheesh24-Jan-08 18:53 
AnswerRe: How to find the user name who are login currently? Pin
N a v a n e e t h24-Jan-08 19:34
N a v a n e e t h24-Jan-08 19:34 
GeneralRe: How to find the user name who are login currently? Pin
Sutheesh24-Jan-08 19:59
Sutheesh24-Jan-08 19:59 
GeneralRe: How to find the user name who are login currently? Pin
N a v a n e e t h24-Jan-08 20:28
N a v a n e e t h24-Jan-08 20:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.